How to be notified when a job has finished
Date: Wed, 27 Feb 2008 04:43:33 -0800 (PST)
I have triggers that submit jobs to the user_jobs via this command:
dbms_job.submit( jobno, 'dbms_mview.refresh(''MY_MV'', ''C'');' );
Is there a possibility to beeing informed when the job finishes ?
(An alternate and not elegant solution would be to poll every minute
the user_jobs queue and check if the
jobno is still there)
Can anyone help ?
Anis Received on Wed Feb 27 2008 - 06:43:33 CST