Hello, I am working on to create an email at a certain format (template) in the message body to a ticket system when a SQL job fails.
My question is that:
1) how can retrieve the error message from SQL server, i.e. which step, error code, error message.
2) I understand that SQL can send the notification as email when a job fails as a built-in function, but this email doesn't contain the template format the ticket system require, is there a way to customize it?
Thanks,
fshguo.