Donnie Taylor at myITforum.com

Check how long ConfigMgr Site Maintenance Tasks run

Here is a quick and dirty SQL script that will list the site maintenance tasks and how long they ran last.  Run this in SQL Management Studio and target your ConfigMgr database.

select *,
floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/3600) as Hours,
floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/60)- floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/3600)*60 as Minutes,
floor(DATEDIFF(ss,laststarttime,lastcompletiontime))- floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/60)*60 as TotalSeconds
from SQLTaskStatus



Posted: Dec 08 2009, 02:00 PM by dtaylor | with no comments
Filed under: ,

Comments

No Comments