Re: Can i make a scheduled job in my oracle, to run every night - I need a hint

ohahaahr_at_hotmail.com wrote:
> Hi !
>
> I have a small script, that updates some fields in a table.
>
> Can my oracle run this as a scheduled task every night ?
>
> If yes - how ???
>
> (I am using TOAD)
>
>
>
> Regards,
> Ole

Wrap the scrip in:

CREATE OR REPLACE PROCEDURE <proc_name> IS

   <you code here>
END <proc_name>;
/

Then use DBMS_JOB or DBMS_SCHEDULER to execute it. This will give you total control, operating system independence, and in-database error handling.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)