Completion constants specify success or failure status for Microsoft® SQL Server™ Agent execution attempts. For example, use job completion status constants to control operator notification on execution completion.
| Constant | Value | Description |
|---|---|---|
| SQLDMOComp_All | 6 | Any completion status |
| SQLDMOComp_Always | 3 | Succeeded or failed to complete |
| SQLDMOComp_Failure | 2 | Failed to complete |
| SQLDMOComp_None | 0 | No value set |
| SQLDMOComp_Success | 1 | Succeeded |
| SQLDMOComp_Unknown | 4096 | Invalid value |