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

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.

can_commit

See Also

plsqlTopic

onsiteTopic