I got one more problem, your tip works fine but now i need to know when the job stops. If i give the user 'sysadmin' permissions he can get the...

you need to add the SQLDMO.DLL to your project, and then try this code

Public Sub ExecutJob(JobName As String, Server As String)

Dim oJob As New SQLDMO.Job

Dim sqlServer As New SQLDMO.sqlServer

'Trusted connection

sqlServer.LoginSecure...

rmarda code works fine if you just have first and last name. If you a complete name you need something like this

SELECT LEFT(fullname,CHARINDEX(' ', fullname, 1) - 1) AS fname,...

Where do i grant this permissions (database role 'TargetServersRole') because i can't find it anywhere!

Thanks

I don't want to run the package, but run the job that i scheduled for the package. When i try to do it for this users they could not see...