Check batch jobs

[desi5pure]

(SQL Server 2000) - Every morning, I need to check about 30 jobs to see if they ran OK or not; is there a better way of doing this than opening each job separately.
Is there a SP (stored procedure) that can grab status from each job and display so I don't have to open each job separately?

 

[JayKusch]

	SELECT DISTINCT j.[name] JobName,
		jh2.[LastRunDateTime],
		jh.run_status [Status],
		j.enabled as Enabled,
		jh.[message] Message
	FROM msdb.dbo.sysjobs j
			LEFT OUTER JOIN (SELECT job_id,
								MAX(CAST(STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' + STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)) AS [LastRunDateTime]
							FROM msdb.dbo.sysjobhistory jh
							WHERE step_id = 0
							GROUP BY job_id) jh2
				ON j.job_id = jh2.job_id
			INNER JOIN msdb.dbo.sysjobhistory jh
				ON jh2.job_id = jh.job_id
				AND jh2.[LastRunDateTime] = CAST(STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' + STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)
	WHERE jh.run_status NOT IN (1,3)
		AND jh.step_id = 0

Thanks

J. Kusch

 

[desi5pure]

Thank you so much. I appreciate your help!