Monitor Maintenance Tasks

To monitor last start and last completed times for maintenance tasks in SCCM, run the below SQL queries. At the bottom of this page is an example of running a maintenance task on demand. select * from SQLTaskStatus Order by LastStartTime desc To calculate the duration of each task, the above query can me modified…