Report Long Running Tasks queries the micstats database and report back information about any tasks that have be running longer than the specified time interval.

Input Parameters

  • ReportLongTasks_Time (Required) - The number of seconds, minutes, hours, or days a task must have been running to be included in the report.
  • ReportLongTasks_Unit (Required) - Specifies whether the ReportLongTasks_Time parameter is in seconds, minutes, hours, or days.
  • ReportLongTasks_CommandTimeout - The timeout in seconds to use when performing database queries. Default is 180 seconds (3 minutes).

Output Parameters

  • ReportLongTasks_Results
    • If one of more tasks are found, a list of tasks that have been running longer than the specified length of time is returned.
    • If no tasks are founds, a summary line stating that "0" tasks were found is returned.
    • If errors occur, a blank string is returned.

Notes

The most common use for the output parameter ReportLongTasks_Results is in a message body for a Send Email step that occurs after the Run Script step for Report Long Running Tasks.