Is there a way to get the list of users that are able to stop jobs?

  • Hello all,

    I need to know who stopped a job ( Since nobody besides of myself should be able to do it...) Is there a way to get the list of the users whit that kind of permission?

    Thanks!

  • Anybody with sysadmin rights can do it. Or the owner of the job. Or anyone with the SQLAgentOperator Role.

    As far as a list. Not off the top of my head. But those would be able to accomplish it.

    Keep in mind that my experience shows that the sysadmin role often includes the machine admins it is entirely possible they did it. However, doesn't your sql agent job log show who cancelled it?

    CEWII

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

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