Hi,
What permission / privilege / role should be given to a user who can
just run the scheduled jobs without modifying the jobs or any other
database access?
Thanks
John Jayaseelan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!John,
I do not think that you can. You may have to write an app that logins with a
powerful enough account and present a list of jobs with a start button. If
they own the job they could do it, but then they can change the job.
From the BOL for sp_start_job:
Execute permissions default to the public role in the msdb database. A user
who can execute this procedure and is a member of the sysadmin fixed role ca
n start any job. A user who is not a member of the sysadmin role can use sp_
start_job to start only the
jobs he/she owns.
Norman
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment