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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can i make a scheduled job in my oracle, to run every night - I need a hint

From: Dmytro Dekhtyaryuk <dekhtyaryuk_at_materna.de>
Date: Wed, 26 Oct 2005 10:26:43 +0200
Message-ID: <djnek4$rb9$1@pentheus.materna.de>

<ohahaahr_at_hotmail.com> schrieb im Newsbeitrag news:1130312740.445363.174030_at_o13g2000cwo.googlegroups.com...
> 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
>

Hallo,
rewrite your script as a procedure (for example in schema scott - the procedure prc_your_script) and then:
declare
v_job_nr number;
begin
dbms_job.submit(v_job_nr, 'scott.prc_your_script', sysdate, trunc(sysdate)+1+23/24, false);
commit;
end;

The job starts every night at 23:00.

Regards
Dmytro Dekhtyaryuk Received on Wed Oct 26 2005 - 03:26:43 CDT