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

6 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. Wonderful post!!Thanks for sharing the impressive blog of the post like php jobs in hyderabad

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

    ReplyDelete
  6. 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