Showing posts with label msdb sql agent server sysjobs. Show all posts
Showing posts with label msdb sql agent server sysjobs. Show all posts

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