-
Hi Gurus,
Can anyone tell me what this dbms job code does?
VARIABLE v_JobNum NUMBER
BEGIN
DBMS_JOB.SUBMIT(:v_JobNum, 'PQT_LES_UPLOAD;', SYSDATE, 'SYSDATE + 1/24');
END;
/
Thanks!
Hemant
-
Hi,
It will execute PQT_LES_UPLOAD procedure in 1 hr gap.
i.e. if u submit & execute it 08/08/02 10:00: a.m next
it will execute at 08/08/02 11:00: a.m . U can see the details in user_jobs as well as dba_job.
Manoj
-
This code will create dbms job with first execution of PQT_LES_UPLOAD procedure at submit time and then it
will be scheduled for execution with 1 hr interval.
Regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|