Re: Automatic Firing of Procedure/Trigger

Use a Job (Look at the sys.dbms_job package)

decare
 v_job number;
begin

   dbms_job.submit( v_job,

                    'update TABLEX set ...;',
                    sysdate,
                    'trunc(sysdate + 1 + (1 / 24) * 8'
                  );

Be shure that the parameters
  job_queue_processes
  job_queue_interval
are set.

Marcus

siva_kb_at_yahoo.co.uk (Kishan) 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 - 16:23:27 CEST