February 19, 2004 at 2:05 pm
Hi everyone,
I would like for my developers to be able to view jobs, job history and if the job is running (no start or stop, no enable or disable). Is there a fixed database role that will allow this?
As far as I see one does not exist, so my thought was too create a user defined role and grant access (select) on sysjobs and sysjobhistory and allow execute on sp_who2, and a few other sprocs that details the jobs.
Some background...in our environment the dev's are only datareaders in production, however for this particular project te dev's have set up some jobs on test, I approved after a review and implement on Production. I would like for them to be able to get some info on those jobs.
Do any of you foresee any problems with this? Has anyone granted their developers permissions like this? Your thoughts, suggestions and reccommendations are welcomed.
TIA,
aurora1
Aurora
February 19, 2004 at 2:28 pm
Check sp_help_job and sp_help_jobhistory.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply