what does this dbms job code do?

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!

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.