| |
 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Overview and
Examples of dbms_job Functions
The myinst parameter allows the job queue affinity to be set
in the resulting statement.
To recreate the job creation script for job 99,
do the following:
VARIABLE
l_my_call VARCHAR2(1000);
BEGIN
DBMS_JOB.user_export (
job =>
99,
mycall =>
:l_my_call);
END;
/
PRINT
l_my_call
L_MY_CALL
--------------------------------------------------------------------------
---------------------------------------------
dbms_job.isubmit (job=>99,what=>'my_job_proc(''DBMS_JOB.ISUBMIT
Example.''
;',next_date=>to_date('2004-06-22:11:36:23','Y
YYY-MM-DD:HH24:MI:SS'),interval=>'SYSDATE + 1/24 /* 1 Hour
*/',no_parse=>TRUE);
|
