Custom Email to notify of completed job RRS feed

  • Question

  • Hello:


    What is the simplest way to create a custom email to inform of a successful or failed job. I realize that by default you can send the email to an operator within a SQL Agent Job and that will give a default email subject and body. If I want to customize that message (but still have the start time, end time, duration, success/failed) in the body, what is the best way to do this?


    Should i just create a second step in the job and use sp_send_dbmail? If so, where so I get all the information on the previous step in the job?





    Monday, June 9, 2008 7:19 AM