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] [EMAIL PROTECTED] On Behalf Of Andi Afandi
[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 10:28 AM
To: [email protected]
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]
