I have set email notification on the completition of a scheduled job.
Is it possible to customize the email content?
Sql-server – Sql Server Agent notification email with custom message
sql serversql-server-agent
Related Question
- SQL Server 2008 – How to Send an Email When a Job Step Fails but Overall Job Succeeds
- Sql-server – SQL Server Agent Notification Email if a Step has an error, but the job is succesfull
- SQL Agent Job Notification – Email Without Configuring Database Mail
- SQL Server Agent – How to Capture Error Message from One Step in Another Step
- Sql-server – How to enable email notification for failover in SQL Server
Best Answer
The way I've done this in the past is added a final step to the job, then I can use Database Mail to customize everything about the message (subject, body, recipients, from, etc) based on the server, the status/outcome of the job, and even the duration.
It is cumbersome if you have a lot of jobs, but I did this for a variety of other reasons as well (for example, other actions to perform in addition to sending an e-mail).
You may also consider a management tool like SQL Sentry which provides lots of flexibility over how to handle successful/failed jobs, and has comprehensive options for subsequent actions.