How to get job failure log from sql server management studio 2014


Currently, we are getting job failure alerts from sqlserver agent properties where we have specified the email address

to where notification comes whenever job fails, but we wanted the "job failure log" along with job failure to the

email.We do not have access to joblog.Open Sqlserver management studio 2014 under it, expand a serverlog node,

expand Management, and click SQL Server Logs of failed job.My question is how to get job log by writing a script.

Thanks in advance.

Ms Radha

here is a link

hope it helps :slight_smile: