Report Long Running Tasks

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 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 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.