Allow User to Run Jobs

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737475

  More actions

  April 30, 2020 at 4:11 pm

  #3747736

  A common question, but allow a normal (non sysadmin) to run a specific job.

  I'd like an article that shows 3 jobs in a system.

  • Job 1 - User A can only run this job. User B can run this job
  • Job 2 - User B can this job.
  • Job 3- only the sysadmin can run this

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 1, 2020 at 5:10 pm

  #3748173

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• nesithw

  Grasshopper

  Points: 20

  More actions

  May 2, 2020 at 10:57 am

  #3748329

  I would like to take this on as my first attempt at writing an article, are there any deadlines?

  • This reply was modified 4 years, 11 months ago by  nesithw.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737475

  More actions

  May 4, 2020 at 4:41 pm

  #3748728

  No. you can look at some of our other articles and then submit online (upper right, Write for Us).

  Think essay

  • tell me what you will cover
  • tell me the details
  • tell me what you taught me

  Assume the reader knows SQL Server, but doesn't know how to configure Agent and security for this. Focus on the topics, show examples, spell check, proof, and format code.

  Use images to explain, refer to images in the text. Make sure the reader knows what to look at.

• February 1, 2022 at 12:29 pm

  This was removed by the editor as SPAM