Post reply

sql server job has been modified by some DBA/user, I want to know which user modified/change job.

  • January 26, 2018 at 5:27 am

    #343431

    Is there any way to findout who made last changes in a particular job using SQL Server default trace? Several DBA won't accept rather I just find it from system.

    Shamshad Ali Khatri

  • January 26, 2018 at 5:35 am

    #1977504

    Unfortunately not.  You'll need to have set something up in advance.  I think a trigger on sysjobs would work.

    John

  • January 26, 2018 at 5:35 am

    #1977505

    Might be in the default trace, I can't remember if jobs are one of the things it tracks.
    Other than that, you'd need custom monitoring

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 26, 2018 at 5:58 am

    #1977508

    OK, but how to do that? any suggestion, steps, or some reference? which help implement this working...

  • January 26, 2018 at 6:14 am

    #1977511

    John gave you a suggestion

    John Mitchell-245523 - Friday, January 26, 2018 5:35 AM

    You'll need to have set something up in advance.  I think a trigger on sysjobs would work.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 26, 2018 at 8:36 am

    #1977538

    Getting started with the default trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

    I don't see any events in there that would track jobs.

Viewing 6 posts - 1 through 5 (of 5 total)

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