jcs.add_job_note

PL/SQL API jcs.add_job_note

Summary

function add_job_note(p_jobid in number, p_user in varchar2, p_text in varchar2, p_can_commit in varchar2) return number

Add a note (small comment) to a job that can be read by all users.

Specification

Copy

function add_job_note(p_jobid in number,
p_user in varchar2,
p_text in varchar2,
p_can_commit in varchar2 default const.jcs_yes)
    return number

Parameters

p_jobid - the ID of the job to add the note to
p_user - the user that becomes owner of the note
p_text - the note text
p_can_commit - the action is committed if this parameter is 'Y'
returns number - the ID of the note

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.