SQL-DMO
Replication Task Status Constants (SQLDMO_TASKSTATUS_TYPE)
Replication task status constants represent the execution state of a Microsoft® SQL Server™ Agent job performing a replication task.
| Constant | Value | Description |
|---|---|---|
| SQLDMOTask_Failed | 6 | At least one job failed to execute. |
| 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 executed successfully. |