Home Forums SQL Server 2012 SQL 2012 - General Capture SQL Server Agent Job Last Execution Time RE: Capture SQL Server Agent Job Last Execution Time

  • June 30, 2016 at 4:51 am

    #1887815

    If you are truncating job history, you may have a lot of jobs you can't get rid of because it shows no history.

    In which case you'll want to search for jobs that have never been executed. But then you'll have to figure out how to tell the difference between new jobs that haven't been executed yet and old jobs that have no history for them. Fun, yeah?

    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.