variable x number;
exec
DBMS_JOB.SUBMIT(:X,'Nama_proses_yg_akan_dijalankan;',to_date('15/03/2007
07:04:58','dd/mm/yyyy hh24:mi:ss'),'SYSDATE+1');On 3/14/07, chiank <[EMAIL PROTECTED]> wrote: > > On 14 Mar 2007 01:04:12 -0700, Johannes Christian > <[EMAIL PROTECTED] <johannes.sitorus%40pacomnet.com>> wrote: > > > > > > > > > > > > > > Dear list, > > > > Gimana sih caranya menambahkan jobs di oracle 9i untuk menjalankan suatu > > prosedur setiap jam 7 pagi. Mohon bantuan teman-teman.Thx > > contoh dengan dbms_job > > DECLARE jobno number; > BEGIN > DBMS_JOB.SUBMIT(jobno, > 'nama_procedure;', > sysdate(terserah mau kapan first run), > 'trunc(sysdate+1) + 7/24'); > COMMIT; > END; > > moga membantu > > -- > > chiank > > [Non-text portions of this message have been removed]
