up vote 0 down vote favorite
share [g+] share [fb]

can I query the schedule of a maintenance plan? I want to automate checking that backups were run. Thanks

link|improve this question
feedback

2 Answers

up vote 2 down vote

What about setting up an Operator, configuring Database Mail, and having an email sent whenever the job runs?

link|improve this answer
feedback
up vote 1 down vote

Check out the sysmaintplan_logdetail table in MSDB. It contains the start and end time of jobs that were run as well as if they succeeded.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard