SYS_GETBACKGROUNDJOB

SQL Guide : System stored procedures : Miscellaneous stored procedures : SYS_GETBACKGROUNDJOB_INFO

SYS_GETBACKGROUNDJOB_INFO

The SYS_GETBACKGROUNDJOB_INFO system stored procedure retrieves information from the SYS_BACKGROUNDJOB_INFO table.

CREATE PROCEDURE SYS_GETBACKGROUNDJOB_INFO(
  jobid INTEGER) RETURNS(
  ID INTEGER,
  STMT WVARCHAR,
  USER_ID INTEGER,
  ERROR_CODE INTEGER,
  ERROR_TEXT INTEGER
)

The SYS_GETBACKGROUNDJOB_INFO procedure returns the row that matches the given jobid. The jobid is the job ID of the START AFTER COMMIT statement that was executed. The job ID is returned by the server when the START AFTER COMMIT statement is executed.