Adventures in Database Administration
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
Older Posts
Home
Subscribe to:
Posts (Atom)