Job Completion Constants (SQLDMO_COMPLETION_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Completion constants specify success or failure status for 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 |
Returns jobs of any completion status. |
SQLDMOComp_Always |
3 |
The job succeeded or failed to complete. |
SQLDMOComp_Failure |
2 |
The job failed to complete. |
SQLDMOComp_None |
0 |
No value is set. |
SQLDMOComp_Success |
1 |
The job succeeded. |
SQLDMOComp_Unknown |
4096 |
The completion type could not be determined. |
See Also