Hi Swajit,
Consult the Oracle documentation about the DBMS_JOB package which works
just like Unix cron. The good part is that it is internal to Oracle and
the database.
HTH,
- Swajit Satam <swajit_at_mahindrabt.com> wrote:
> Hi
>
> Can I Execute a procedure depending upon time or
> say at a regular interval (like Triggers but triggers are
> event driven ).
> If it's a Unix box then I can write a cron job but if it's a NT Box then
> it cannot be achived so can it be done inside Oracle itself so that i
> dont have to depend no O/S. or is there any work around for the same.
>
>
> TIA
> Swajit
>
>
>
>
> --
> Author: Swajit Satam
> INET: swajit_at_mahindrabt.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Thu May 25 2000 - 08:43:47 CDT