Post reply

how can a user see Jobs without sa permissions

  • March 30, 2004 at 3:18 am

    #84546

    Hello,

    a sql user would like to see if his jobs (DTS) has run or not.  I gave him datareader right on msdb but he still doesnt see the jobs. And i didn't want to give him sa rights.

    could somebody helps?

     

  • March 30, 2004 at 4:38 am

    #501035

    If he is the owner of the jobs (as shown on each job's General tab) he should be able to see them thru Enterprise Manager.


    Cheers,
    - Mark

  • March 30, 2004 at 4:42 am

    #501036

    Mark,

    he cant be owner of the job because the job needs to run as NT/administrators.

     

  • March 30, 2004 at 4:53 am

    #501038

    .... then I think you're (or he's) stuck when it come to viewing the jobs through EM, because a lot of the SPs relied upon by EM actually check the login explicitly, so that rules out simply granting execute permission too.

    Given that he has db_datareader access, an option is for him to write/run scripts that read the msdb tables directly and print the job and jobstep results.

     


    Cheers,
    - Mark

  • March 30, 2004 at 5:38 am

    #501045

    There is a role in msdb called TargetserverRole, which allows members to view the jobs in EM.

  • March 30, 2004 at 6:02 am

    #501051

    Hello Rootman,

    great it works!!!!!!!!

    Thank You!!!!!

  • March 30, 2004 at 6:47 am

    #501060

    Just keep in mind this is undocumented and subject to change. For instance, permissions this role had were changed with SP3. So if you make use of it, test in dev before slapping SP4 on in production (if/when it comes out).

    K. Brian Kelley
    @kbriankelley

  • March 30, 2004 at 6:53 am

    #501063

    Ok Brian, i will keep it in mind.

    Thanks

  • March 30, 2004 at 3:04 pm

    #501194

    Thanks from me too rootman.


    Cheers,
    - Mark

  • April 8, 2004 at 11:46 am

    #502191

    Okay this is great up to a point.  I placed the development team in this role and they are quite happy to see the jobs and jobs history.  Now the complaint is that they cannot see the current status of the job.  How can I modify the permissions of this role to allow members to see the current job status?

    "Give 'em an inch, they ask for a lightyear"

    Glen

Viewing 10 posts - 1 through 9 (of 9 total)

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