How to be notified when a job has finished
From: <anisbenh_at_gmail.com>
Date: Wed, 27 Feb 2008 04:43:33 -0800 (PST)
Message-ID: <dd7aa973-4322-455b-938a-ba922057b4d6@d21g2000prf.googlegroups.com>
Date: Wed, 27 Feb 2008 04:43:33 -0800 (PST)
Message-ID: <dd7aa973-4322-455b-938a-ba922057b4d6@d21g2000prf.googlegroups.com>
Hi,
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 ?
Thanx,
Anis
Received on Wed Feb 27 2008 - 06:43:33 CST