Microsoft® SQL Server 2012 Unleashed

Testing the Job-Completion Notification

To test the email configuration and notification you just set up, you right-click the job name under the Jobs folder and then select Start Job. If everything is set up properly, an email message appears in your inbox, indicating the job’s successful completion. Its body text might look something like this:

Click here to view code image

JOB RUN:    'Database Mail Test Job' was run on 5/7/2009 at8:37:22 PMDURATION:    0 hours, 0 minutes, 0 secondsSTATUS:    SucceededMESSAGES:    The job succeeded.  The Job was invoked by User[TestUser].    The last step to run was step 1 (Test Mail Step 1).