Maintenance Plan notifications

[knicholson]

I am using SMTP to send out an email notification to inform me whether my backups were successful or not. The problem I have is that xp_sqlmaint does not set a return code. Without a return code to test, I do not know whether to send a success or unsuccessful message. Does any one have an idea on how to accomplish this?

Thanks,
Ken Nicholson

[rmiao]

You can check job status instead of.

[knicholson]

Where do I find job status? Is there a system variable that contains job status?

[rmiao]

You can get it with msdb..sp_help_job or by querying msdb..sysjobhistory.