Permissions Needed for sp_start_job 1

[JohnBates]

hi everyone,

I have a need to enable 1 user to execute a certain job.

'dbo' is the jobs owner and the user has 'dbo' permissions in the msbs and the user database.

When the user executes:
use msdb
exec sp_start_job 'the job name'

they get "Job does not exist"

What are the other permissions I need to grant so they can execute this job?

Thanks, John

 

[SQLBill]

Does the job exist? Make sure the job name is spelled correctly.

-SQLBill

Posting advice: FAQ481-4875

 

[JohnBates]

yes, I checked that.

When I log in as this user, this job (actually no jobs show) does not appear in the Jobs window in Ent Mgr.

 

[mrdenny]

That's because as a non-sysadmin the user can not run jobs that they do not own.

For the user to be able to start the job, they would need to be the job owner (and would need to have permissions to do everything that the job needs to be able to do as the job would then be running under there login).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

Thanks mrdenny. You talked me out of it. Bad idea.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com