Execute Job

Question

Execute Job

TriggerMe

SSChampion

Points: 11752
More actions
September 6, 2006 at 8:47 pm

#61331

I have a user who has access to a Development SQL Server to 1 Database. This user has db_owner permissions to this Database.
How do I allow this user access to execute a Job?
When the user logs in, the user cannot see any of the Jobs.
Kindest Regards,

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 1

DB Owner gives complete access to the database. To be able to run JOb the user must be assigned to "processadmin" fixed server role(thats erver wide permission and he can run any jobs)

Hope this helps

Thanks

Sreejith

TriggerMe SSChampion Points: 11752 More actions · Answer 2

Ok thanks. I thought that perhaps I could restrict the jobs that a user can use.

Kindest Regards,

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

I thought that processadmin could only kill processes. I recommend creating a new database role in msdb, adding the user to it, and granting EXECUTE permissions to the following stored procedures:

sp_start_job

sp_stop_job

sp_help_job

sp_help_jobstep

sp_help_jobschedule

sp_help_jobhistory

That should allow him to see, start, and stop jobs without being a member of sysadmin.

Greg