Job Completion Constants (SQLDMO_COMPLETION_TYPE)

SQL-DMO

SQL-DMO

Job Completion Constants (SQLDMO_COMPLETION_TYPE)

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

See Also

DeleteLevel Property

EmailLevel Property

NetSendLevel Property

PageLevel Property