Job status

Notifications help you monitor the execution results for your jobs across multiple databases and schedules.

The following table provides the job status for execution of different type of scripts:
Script Success Error Warning Stopped

JDBC - only one statement

The statement is executed successfully.

SQL error is returned during execution or credential error and other backend error.

SQL warning is returned during execution.

The job is stopped by the user or due to timeout.

JDBC - multiple statements

All the statements are executed successfully, without any error or warning.

At lease one statement has error. If there is both error and warning, the job will show error status as priority.

The job will stop at the current statement when an error is received.

There is no error, but at lease one statement has SQL warning.

The job is stopped by the user or due to timeout.

CLP - only one statement

The statement is executed successfully, without any Db2 error.

SQL error is returned during execution or SSH error and other backend error.

SQL warning is returned during execution.

The job is stopped by the user or due to timeout.

CLP - multiple statements

All the statements are executed successfully, without any error or warning.

At lease one statement has error. The job will stop at the current statement when an error is received.

 

The job is stopped by the user or due to timeout.

Shell - only one command

The command is executed successfully

SSH error and shell error and other backend error.

 

The job is stopped due to timeout.

Shell - multiple commands

All the commands are executed successfully. Unrecognized commands are ignored.

SSH error and shell error and other backend error.

 

The job is stopped due to timeout.