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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s