Hi,
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.
Regards,
Ms Radha