How to view Job History a User Login

• cbadiseshan

  Mr or Mrs. 500

  Points: 566

  More actions

  March 5, 2004 at 2:48 am

  #84233

  Can anyone let me know immediately, how to view job history for a User Created Login. To some extent, i know, create a role which contacts suitable msdb jobs rights.. (but dont know which one i should give for this role) and then assign the user created login to this role.

  Thanks,

  sesh

• fhanlon

  SSChampion

  Points: 13131

  More actions

  March 5, 2004 at 11:53 am

  #497611

  Please explain.  Jobs are jobs.... users are users.  Job histories belong to jobs period.  There is no relationship between jobs and logins. 

  Francis

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 5, 2004 at 1:09 pm

  #497639

  Ok, I am assuming you want to let a login who is not part of sysadmin view the job history.

  First you must configure the proxy account for the SQL Sever Agent then you can add that login to TargetServersRole in msdb. I hope you are using SS 2000 sp3

  is that what you wanted?

   

  
  * Noel

• cbadiseshan

  Mr or Mrs. 500

  Points: 566

  More actions

  March 8, 2004 at 4:34 am

  #497753

  Guys,

  Thanks for your msgs. Now i have resolved this issue. Actually there is one Windows NT login which is needed to give permissions to view Jobs created on the server.

  It has been added to new role and given select access to 5 tables which are related to job related tables.

  Thanks to all your help.

  Regards,

  Adiseshan