You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

← jcs.setuserjcs.set_date_timezone →

on-site-related topic PL/SQL API jcs.set_current_job_status

Summary

Set the end status for the current job.

Normally, a PL/SQL job ends with COMPLETED and return_code NULL, or with ERROR and a non-zero return_code when it raises an error. This procedure allows you to override the status and return_code.

It is normally used from a JCS_POST_RUNNING_ACTION to examine the job results and define different behaviour than normal.

This can be called from:

  • the main code of a PL/SQL job
  • in a JCS_PRE_RUNNING_ACTION procedure
  • in a JCS_POST_RUNNING_ACTION procedure

Specification

procedure set_current_job_status(status in varchar2,
return_code in number default null)

Parameters

  • status - the status or statuscode that the job should get
  • return_code - in case of ERROR, the exact return_code that the job should get

plsqlTopic

onsiteTopic

← jcs.setuserjcs.set_date_timezone →