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://karaszi.com/mailafterjob-send-email-after-agent-job-include-ouput-files. Feedback is of course very welcome.