Post reply

Server role to read job

  • June 6, 2006 at 9:30 am

    #60807

    Right now on production server, I assigned all the developers to have public role to certain databases.  Now the developers demand to see the job.  Is there any server role that allows people to see the job only but not execute the job?

    Thanks

     

     

  • June 6, 2006 at 9:31 am

    #642048

    I dont think there is any direct role to add your developers to see jobs.  But in SQL2005 we have this feature.

    Thanks-Mubeen Mohammed

  • June 6, 2006 at 3:43 pm

    #642146

    Try adding users to the TargetServersRole role in msdb.  It's really meant for remote server administration, but it has the correct permissions for seeing jobs with being in Sysadmin.

    You may need to add execute permission to sp_help_job and sp_help_jobhistory, but try it first.

    Greg

    Greg

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

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