PL/SQL API jcs.job_statuscode

Summary

• function job_statuscode(job_id in number) return varchar2

Returns the statuscode of a job.

The statuscode indicates how the job is progressing. It is an 1 character internal code and is useful in programming since it is never changed or translated.

You can see all valid job statuses in jcs_job_statuses (not implemented).

Specification

function job_statuscode(job_id in number)
    return varchar2

Parameters

• job_id - the ID of the job
• returns varchar2 - the statuscode of the job

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

See Also

• jcs.job_status

plsqlTopic

onsiteTopic