Difference between revisions of "SQWareProduction:oracle:etc:sqwora CreDb CrontabRef.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 5: Line 5:
 
File content:
 
File content:
 
<pre>
 
<pre>
 +
## mm(0-59) hh(0-23) dd(1-31) MM(0-12) DAY(0-sunday, 1-monday, ...) command
 
#Purge alert
 
#Purge alert
 
00 08 * * 0  ksh -c '. $HOME/.profile <ORACLE_SID>;$gvsqw_OraBin/sqwora_RunJob.ksh -I <ORACLE_SID> -A PurgeAlert > $HOME/tmp/PurgeAlert_<ORACLE_SID>.log 2>&1'
 
00 08 * * 0  ksh -c '. $HOME/.profile <ORACLE_SID>;$gvsqw_OraBin/sqwora_RunJob.ksh -I <ORACLE_SID> -A PurgeAlert > $HOME/tmp/PurgeAlert_<ORACLE_SID>.log 2>&1'

Revision as of 11:54, 23 January 2012

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_CrontabRef.cfg:



File content:

## mm(0-59) hh(0-23) dd(1-31) MM(0-12) DAY(0-sunday, 1-monday, ...) command
#Purge alert
00 08 * * 0   ksh -c '. $HOME/.profile <ORACLE_SID>;$gvsqw_OraBin/sqwora_RunJob.ksh -I <ORACLE_SID> -A PurgeAlert > $HOME/tmp/PurgeAlert_<ORACLE_SID>.log 2>&1'
#Backups
00 20 * * 5   ksh -c '. $HOME/.profile <ORACLE_SID>;$gvsqw_OraBin/sqwora_RunJob.ksh -I <ORACLE_SID> -A RmanFull > $HOME/tmp/RmanFull_<ORACLE_SID>.log 2>&1'
00 20 * * 0-4 ksh -c '. $HOME/.profile <ORACLE_SID>;$gvsqw_OraBin/sqwora_RunJob.ksh -I <ORACLE_SID> -A RmanInc > $HOME/tmp/RmanInc_<ORACLE_SID>.log 2>&1'