I was wondering if someone knows what tables the history for maintenance plans are stored? I want to query the start time and end time to get an elapsed time so I can better schedule my jobs.
You can find maintenance plan specific information in msdb.dbo.sysdbmaintplan_history. But since a maintenace plan results in one or more jobs you can also use msdb.dbo.sysjobhistory.
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply