How to allow a user to consult all jobs in my server, using SSMS?

• Haley

  SSC Veteran

  Points: 234

  More actions

  March 15, 2017 at 10:38 am

  #319665

  Hello,

  I need some help with SQL Server 2012, please!

  How to allow a user to consult all jobs in my server, using SSMS?

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 15, 2017 at 10:55 am

  #1933297

  What do you mean by "consult"?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 15, 2017 at 10:57 am

  #1933298

  This may help: https://docs.microsoft.com/en-us/sql/ssms/agent/configure-a-user-to-create-and-manage-sql-server-agent-jobs.

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  March 15, 2017 at 6:39 pm

  #1933388

  Haley - Wednesday, March 15, 2017 10:38 AM

  Hello,

  I need some help with SQL Server 2012, please!

  How to allow a user to consult all jobs in my server, using SSMS?

  Thanks

  To be honest, I wouldn't allow that.  Figure out what they need and send it to them in an email.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)