We have a overnight SQL job that upon completion sends out an email.
Everything works fine, but I'd like to change the subject line of the email. I can not figure out where the subject line is defined. At this point it seems to me that the format of the email is a default.
We get the following in the email ...
From: IT Adminsistrator (Administrator@company.com)
To: me; you
Subject: SQL Server Job System: 'Overnight_Job' completed on \\TestServer
Jub Run: 'Overnight_Job' was run on mm/dd/yyyy at 2:30 am
Duration: 10 minutes
Messages: The Job succeeded. The job was invoked by Schedule 17 (Overnight_Job) . The last step run was step 20 (step 12c)
Is there a way to change the Subject line? In the Subject line, I'd like to include Success or Failure, put the Server name first and the job name last.