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

4 comments:

  1. Any Idea about who Created the Job?

    ReplyDelete
  2. @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. This comment has been removed by the author.

    ReplyDelete
  4. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/07/27/introduction-to-sql/

    ReplyDelete