PL/SQL API jcs.current_job

Summary

• function current_job(name in varchar2) return varchar2 (Only ''job_id'', ''scheduler_name'', ''scheduler_partition'', ''job_owner'', ''job_user'', ''scheduler_hostname'' and ''os_type'' are available. Note that ''os_type'' is only available for jobs running on a Process Server with a parameter OSFamily. Note that ''scheduler_hostname'' is only available for jobs running on a Process Server with a parameter RemoteHostName. )

Returns information about the current job.

If there is no current job, it returns NULL.

Exceptions

Specification

function current_job(name in varchar2)
    return varchar2

Parameters

• name - desired information, one of:
• 'job_id': Same as jcs.current_job_id
• 'scheduler_partition': the name of the partition of the scheduler the job runs on
• 'scheduler_name': the name of the scheduler the job runs on
• 'job_owner': the user that submitted the job
• 'job_user': the user under which the job logs in into the database
• scheduler parameter: the name of a parameter of the scheduler the job runs on (as found in rs_scheduler_parameters)
• returns varchar2 - requested value

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

Examples

Using jcs.current_job
       create or replace function osdep(nt in varchar2, unix in varchar2)
       return varchar2 is
       begin
         if jcs.current_job('os_type') = 'NT'
         then
           return nt;
         else
           return unix;
         end if;
       end;

       create or replace script show_tempdir
       as osdep('dir c:\temp', 'ls /tmp')

Using jcs.current_job

plsqlTopic

onsiteTopic