How to be notified when a job has finished

From: <>
Date: Wed, 27 Feb 2008 04:43:33 -0800 (PST)
Message-ID: <>


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

Original text of this message