Monday, April 4, 2011

When was a SQL Agent job was created or when was the last time it was modified?

If you ever need to know the date a SQL Agent job was created or the last time it was modified, you can find the information in the sysjobs table in the MSDB database.

Select Name,
       Date_Created,
       Date_Modified
  From msdb..sysjobs
Posted by at
Labels:

6 comments:

  1. UnknownFebruary 2, 2015 at 6:23 AM

    Any Idea about who Created the Job?

    ReplyDelete
  2. RAJAugust 14, 2016 at 7:35 AM

    @Shakeel:

    SQL Server does NOT track who created jobs,it keep the info of just the current owner of the jobs.

    However, the work around is to create your own DDL trigger.

    ReplyDelete
  3. RAJAugust 14, 2016 at 7:35 AM

    This comment has been removed by the author.

    ReplyDelete
  4. UnknownMay 10, 2017 at 1:37 AM

    Wonderful post!!Thanks for sharing the impressive blog of the post like php jobs in hyderabad

    ReplyDelete
  5. rmouniakJuly 5, 2018 at 7:54 AM

    It 's an amazing article and useful for developers
    Sql server DBA Online Course

    ReplyDelete
  6. Mohammed NadeemOctober 2, 2019 at 8:59 PM

    This blog aware me about different programs which can become very useful for our friends and kids. Few websites provide combined courses and few of the are separately for single subject. Glad to get this information.
    Find job on experts24hr

    ReplyDelete

Subscribe to: Post Comments (Atom)