Post reply

Audit changes to scheduled jobs

  • April 30, 2007 at 3:12 pm

    #68618

    Someone has altered one of my maintenance scheduled jobs and I want to find out who.  Is there a quick and easy way to tell who changed a job??  I have a suspicion it is someone on Helpdesk who has too many permissions but I can't do anything without proof..

    Cheers,

    Blair

  • April 30, 2007 at 3:21 pm

    #703421

    Generally speaking, I do not think you can unless you turn on the C2 audit mode.

  • April 30, 2007 at 3:22 pm

    #703422

    MSDB..SysJobs can tell you the last modified date of the job, but not who modified it.  I would suggest revoking permissions from the helpdesk staff,  or anyone for that matter, who you do not want to have the ability to make these types of changes.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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