Home Forums SQL Server 2005 Administering SQL Server 2000 Job History Run Duration RE: SQL Server 2000 Job History Run Duration
Adam Bean
One Orange Chip
Points: 26631
More actions
March 6, 2008 at 6:36 am
#785904
What is it exactly you're attempting to do?
SELECT * FROM msdb.dbo.sysjobs
SELECT * FROM msdb.dbo.sysjobhistory
All your information is in those two tables ... join the job_id's and you're good to go.