Sunday, June 1, 2008

Query To Find SQL Server Agent Job Creation and Modification Date

Here is the small script for finding the creation and modification date of the job for last time.

Select Name,
Date_Created,
Date_Modified
From msdb..sysjobs
Order by Date_Created DESC
Sql server agent. agent job creation date. sql server agent modification date. sql server job timings. sql server agent job history. job history. agent history.history.

0 comments:

Post a Comment