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).

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial