Replication Task Status Constants (SQLDMO_TASKSTATUS_TYPE)

Replication task status constants represent the execution state of a SQL Server Agent job performing a replication task.

Constant Value Description
SQLDMOTask_Failed 6 At least one job has failed to execute successfully
SQLDMOTask_Idle 4 All jobs are scheduled and idle
SQLDMOTask_Pending 0 All jobs are waiting to start
SQLDMOTask_Retry 5 At least one job is attempting to execute after a previous failure
SQLDMOTask_Running 3 At least one job is executing
SQLDMOTask_Starting 1 One or more jobs are starting
SQLDMOTask_Succeeded 2 All jobs have executed successfully

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.