CREATE VIEW dbo.View_FailedJobs AS SELECT JJ.instance_id ,sj.job_id ,sj.name as ‘JOB_NAME’ ,sjt.step_name as ‘STEP_NAME’ ,JJ.run_status ,JJ.sql_message_id ,JJ…
