sp_start_job problem

[thamms]

Hi,

I have a non-admin user that I would like to grant "sp_start_job" permissions to.

I ran this statement successfully:

grant execute on sp_start_job to myNonAdminUser

However, when I log in as this user, and attempt to start a job, it says that the "@job_name does not exist"

The job does exist and will run under a sysadmin user. So this is a permissions issue. How do I resolve this?

Thanks!

 

[mrdenny]

Basically you don't. In order for a non-sysadmin to start a job they must own the job.

If you have SQL 2005 you can put the user into the SQLAgentOperatorRole and they will be able to start all the jobs on the server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog