You are the database administrator for a major shipping company. You manage all the SQL Server 2008 instances of the company.
For one of your instances, you have created jobs to perform regular administrative activities.
Some of these jobs in the database fail because the server went down due to a power failure.
You want to analyze these failed jobs. You also want to find out the tasks performed by these failed jobs.
Which query will you use to achieve the objective?
A.
SELECT job_id, step_id, step_name from msdb.dbo.sysjobhistory
WHERE run_status = 1
B.
SELECT job_id, step_id, step_name from msdb.dbo.sysjobactivity
WHERE run_statu-s1 = 1
C.
SELECT job_id, step_id, step_name from msdb.dbo.sysjobhistory
WHERE run_status = 0
D.
SELECT job_id, step_id, step_name from msdb.dbo.sysjobactivity
WHERE run_status = 0