Re: Oracle Timer?

From: Martin Mayrhofer <mmayrhofer_at_yahoo.com>
Date: Mon, 06 Aug 2001 19:16:45 GMT
Message-ID: <x2Cb7.71920$U27.2066981@news.chello.at>

"Matt Flavin" <mflavin_at_oznet.ksu.edu> schrieb im Newsbeitrag news:3B6EC7E1.2AF6D774_at_oznet.ksu.edu...
> Is am new to Oracle, and need a way to execute a procedure in Oracle on
> a fixed time interval. Does the WHEN-TIMER-EXPIRED trigger only apply
> to Oracle Forms, or can this be used anywhere?
>
> Thanks in advance for any information
>
> Matt Flavin
>

Hi,

You can use the DBMS_JOB Package to submit a job.

Example:

VARIABLE jobno number;
BEGIN
   DBMS_JOB.SUBMIT(:jobno,

      'dbms_ddl.analyze_object(''TABLE'',
      ''DQUON'', ''ACCOUNTS'',
      ''ESTIMATE'', NULL, 50);',
      SYSDATE, 'SYSDATE + 1');

   COMMIT;
END;
/
Statement processed.

PRINT jobno
JOBNO

---

14144

4 more information RTFM .

cu,

Martin Received on Mon Aug 06 2001 - 14:16:45 CDT