Task list

Close

Closes the Task List window.

Refresh

Refreshes the Task List window.

Toggle Enable

Alternates between disabling the highlighted process and enabling the process.

Note: Used only for debugging.

Toggle Instance Enable

Alternates between:

a) disabling the highlighted process and the other processes in that group, and

b) enabling that process and the other processes in that group.

Note: Used only for debugging.

Reset

Select to reset the following counts:

• totalFailed

• numRuns

• NumNoWorkRuns

• avgRunTime

• avgNoWorkRunTime

• maxRunTime

• avgWait

Execute

Runs the highlighted process up to the @BatchSize value (number of rows) for that process.

Execute Instance

Runs the highlighted process and the other processes in that group up to the @BatchSize value (number of rows) for each process run.

Copy

Refreshes the Task List window.

Instance

The group to which the task belongs.

InstanceOrder

The order of execution of tasks within an instance.

taskCode

A unique identifier for each task.

taskName

The name of the task (for stored procedures, this must be the name of the procedure.)

enable

Y or N indicates whether the task will be run.

totalFailed

Number of times that the task has failed to run properly.

numRuns

This value increases by one every time a task is run, regardless of whether there is work completed.

numNoWorkRuns

If a task is run with no work completed, the value will increase by one.

avgRunTime

How long the task took to run, on average, when there was work to do.

avgNoWorkRunTime

How long the task took to run, on average, when there was no work to do.

maxRunTime

The longest amount of time that the task took to run.

waitTime

How long the task has been waiting since it was last run.

interval

How long that the task will wait between runs.

avgWait

The average amount of time that the task waited between runs.

args

Arguments required to run the task.

debugArgs

Additional arguments required to debug the task.