Oracle

Configuring cron Jobs – Oracle crontab

With the exception of the environment setup, each line in the crontab file represents a scheduled task by using the following syntax:

field          allowed values
—–          ————–
minute         0-59
hour           0-23
day of month   1-31
month          1-12
day of week    0-7 (both 0 and 7 are Sunday)
user           Valid OS user
command        Valid command or script.
 
crontab format : 
 
* * * * *  from left to right = minute, hour, day, month, day. 
 
Capture
 
basic scripts link 
 
crontab -e : edit 
crontab -l : list 
 
sysntax :

0-59/5  *  *  *  1-5  *  command
example : 
 
00 06  * * *  this script will run every day at 06 am
 
00 06  * * * /home/oracle/scripts/inspirit/cleanup_trc.sh > /home/oracle/scripts/dba_clean/log/cleanup_trc.log 2>&1
 
 
Br. Erman. 
 
Advertisements
Standard