Henri, Andi's asking about running the shell script from inside the database using DBMS_JOB, not crontab.
2008/6/30 Henri Alia Putra <[EMAIL PROTECTED]>: > > Dear andi, > > to run script job on solaris: > 1. chmod +x /u01/test/test.sh => x execute > 2. you can add cronjob in crontab > export EDITOR=vi > crontab -e > 00 02 30 06 * /u01/test/test.sh > > 00 02 30 06 * command to be executed > - - - - - > | | | | | > | | | | +----- day of week (0 - 6) (Sunday=0) > | | | +------- month (1 - 12) > | | +--------- day of month (1 - 31) > | +----------- hour (0 - 23) > +------------- min (0 - 59) > > for detail see http://www.adminschoice.com/docs/crontab.htm > regards > > Henri > > From: [email protected] <indo-oracle%40yahoogroups.com> [ > [email protected] <indo-oracle%40yahoogroups.com>] On Behalf Of > Andi Afandi [EMAIL PROTECTED] <andi.afandi%40yahoo.com>] > Sent: Monday, June 30, 2008 10:28 AM > To: [email protected] <indo-oracle%40yahoogroups.com> > Subject: External Email : --> [indo-oracle] execute shell script dgn > scheduling > > 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, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
