Job Modifications

  • Hi,

    Can any one let me know where exactly can we capture the changes to the job that has been created an running successfully and what would be the system tables where exaclty I could look for this kind of changes that have happened to the SQL Server Jobs.

    Regards,

    Ravi

  • RaviShankar1234 (5/23/2011)


    ... changes that have happenes to the SQL Server Jobs.

    I don't think SQL Server stored all the changes that you make to a job. I think it stores only changed job.

    Anway, job details are stored in msdb.dbo.sysjobs and msdb.dbo.sysjobsteps tables.

    You can check the backup of msdb database for older version of the job.

  • I would agree with Suresh. I have never seen a place where you can track the changes made to a job over time.

    However, you could set up logging that tracks these changes in the future. If you need this information going forward, that is.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • You could also give SQL Agent Insight a try. This product can notify you when a job has been modified or created via email, however, in this release it won't yet show you what has changed at the step level. That is slated for a future release. It can be found here www.brentec.ca.

    Meanwhile, there are scripts, including powershell ones that will document all jobs with steps, give a search, even on this site.

    Regards.

  • use Database audit specification against msdb database because all jobs information insert or update in this database

    http://msdn.microsoft.com/en-us/library/cc280386.aspx

    http://technet.microsoft.com/en-us/library/cc280404.aspx

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • I've used a trigger on sysjobs to alert me when jobs are enabled/disabled. That worked fine. You could do something similar for sysjobsteps.

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

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