solidDB Help : solidDB reference : SQL: 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.
Go up to
Miscellaneous stored procedures