|
Home > Archive > Other Oracle database topics > October 2005 > Can i make a scheduled job in my oracle, to run every night - I need a hint
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can i make a scheduled job in my oracle, to run every night - I need a hint
|
|
| ohahaahr@hotmail.com 2005-10-27, 7:28 am |
| 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
| |
| Dmytro Dekhtyaryuk 2005-10-27, 7:28 am |
|
<ohahaahr@hotmail.com> schrieb im Newsbeitrag
news:1130312740.445363.174030@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
|
|
|
|
|