Re: Automatic Firing of Procedure/Trigger
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Thu, 13 Sep 2001 13:58:49 GMT
Message-ID: <tY2o7.1134$JN.4647_at_news1.sttls1.wa.home.com>
Date: Thu, 13 Sep 2001 13:58:49 GMT
Message-ID: <tY2o7.1134$JN.4647_at_news1.sttls1.wa.home.com>
Look at the dbms_jobs package. It will do what you want.
Jim
"Kishan" <siva_kb_at_yahoo.co.uk> wrote in message
news:1ef7633f.0109130248.bc75312_at_posting.google.com...
> Hi all:
> I'm using Oracle8i on Windows 2000. Is there a way by which I could
> fire a trigger or a procedure automatically at a specified time? For
> eg. I would like to run a procedure or fire a trigger, which will
> change a status flag in a table at 8:00 in the evening everyday. What
> could I do to accomplish this?
>
> Thanks in advance.
Received on Thu Sep 13 2001 - 15:58:49 CEST