January 6, 2012 at 3:27 am
When a SQL Job sends a notification email it sets the email subject line to something like "SQL Server Job System: '<database> Maintenance.Subplan_1' completed on <sql server instance>". This is a little confusing when the job has failed. Is there any way that I can set the subject line to something else (I'd like to include the word failure somewhere if I can) .
January 6, 2012 at 7:32 am
Maintenance.Subplan_1 comes from the maintenance plan you have set up and named.
You can change the subject based on its name but I'm unaware of anything further.
You "could" create a custom SSIS package to the same job and include an error handler to email a custom email.
January 6, 2012 at 8:01 am
Thanks. I was already aware of where the current details came from, and had already considered SSIS, and also writing my own T-SQL. I was hoping for a quick fix!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply