Re: DBMS_JOB question
From: E. Sedney <101740.245_at_CompuServe.COM>
Date: 1996/05/01
Message-ID: <4m80j9$5bj$3_at_mhadf.production.compuserve.com>#1/1
Date: 1996/05/01
Message-ID: <4m80j9$5bj$3_at_mhadf.production.compuserve.com>#1/1
Hi
This is possible. You can use the package dbms_job to insert the job. The parameter for the interval is optional. Insert a job like
"exec dbms_job.submit(v_var,'myprocedure;',sysdate+1);"
Run the job any time you want with:
"exec dbms_job.run(v_var)"
Change the job with "exec dbms_job.run(v_var)
Remove the job with "exec dbms_job.remove(v_var)
The variable v_var is a binary integer which can be retrieved from the tables dba_jobs, user_jobs or all_jobs once a job is submitted.
Good Luck
E. Sedney
Oracle NL
ESEDNEY_at_nl.oracle.com
Received on Wed May 01 1996 - 00:00:00 CEST