After executing a job, I want to have an email with the following information:
- Success or failure in the mail subject (not just in the body)
- Success or failure and execution time for each job step in mail body
- Have output file(s) for the job steps attached to email
Agent has none of above built-in so I created my own procedure for this. This is meant to be added as a final job step for your jobs. You find all details and the procedure here: http://www.karaszi.com/SQLServer/util_MailAfterJob.asp. Feedback is of course very welcome.