SQL script send failed jobs

------------------

EXEC master..xp_sendmail @recipients = 'mailaddress',

@query =

'select t1.run_date, t2.name, t1.step_name, t1.message from msdb..sysjobhistory t1 inner join msdb..sysjobs t2 on t1.job_id =...