saya coba jawab pak, mgkn teman2 yg lain mau menambahkan. bila ini unix maka bisa dicoba menggunakan crontab dari Unix/OS(solaris) berikut contoh dari crontab :
0 2 30 6 * /u01/test/test.sh crontab atau job schedule diatas akan running pada jam 2.00 am tanggal 30 Juni setiap tahun, bukannya hanya pada tahun 2008. bila shell script ini terdapat syntax2 db, maka buat crontab pada user oracle. CMIIW. On Mon, Jun 30, 2008 at 10:28 AM, Andi Afandi <[EMAIL PROTECTED]> wrote: > Dear all friends, > > We use oracle 9i database. there is not package dbms_scheduler in it. > I got a problem to execute shell script on solaris machine using oracle 9i > scheduler. > The problem is i don't know which package and the syntax should i use to do > it. > Let say the shell script is on '/u01/test/test.sh' > Schedule running at 02.00 am 30-JUN-2008 > What the syntax to execute this job....?? > Is there anyone knows about this...?? > > Thank you very much > > Gruesse > > Afandi > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
