Send notifications on job STEP failures (trigger)

create trigger trg_stepfailures
on sysjobhistory
for insert
as 
declare @strMsg varchar(400),
@strRecipient varchar(128)

set @strRecipient = 'ken.singer@sagepub.com'

if exists (select * from inserted where run_status = 0 and step_name <> '(job outcome)')
begin
select @strMsg = 
convert(char(10),'Server') + char(58) + @@servername +
char(10) +
convert(char(10),'Job') + char(58) + convert(varchar(50), sysjobs.name) + 
char(10) +
convert(char(10),'Step') + char(58) + convert(varchar(50), inserted.step_name)+
char(10) +
convert(char(10),'Message') + char(58) + convert(varchar(150), inserted.message)
frominserted
joinsysjobs
oninserted.job_id = sysjobs.job_id
whereinserted.run_status = 0

raiserror (@strMsg, 16, 10) with log
exec master.dbo.xp_sendmail@recipients = @strRecipient,
@message = @strMsg,
@subject = 'Job Failure'

end