-
Maintenance Plan notifications
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
-
You can check job status instead of.
-
Where do I find job status? Is there a system variable that contains job status?
-
You can get it with msdb..sp_help_job or by querying msdb..sysjobhistory.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|