Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2007-09-17 : 12:19:44
|
| I am trying to write a query that will show me data about SQL agent jobs that I have scheduled. I would like to create a report that shows the results of SQL Agent jobs. Is there a system table or SP that I can use to get this information? |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-17 : 14:14:27
|
select * from msdb..sysjobhistoryonly job that is finished is stored here, not pending nor current.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rwlopez
Yak Posting Veteran
80 Posts |
Posted - 2007-09-17 : 14:31:43
|
| Thanks, This exactly is what I was looking for. |
|
|
|
|
|
|
Data - SQL Agent Jobs