Difference between revisions of "SQWareProduction:ingres:etc:CrontabRef"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
Line 13: Line 13:
 
00 05 * * 6 ksh -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Analyze > $HOME/tmp/Analyze_$INGRES_SID.log 2>&1'
 
00 05 * * 6 ksh -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Analyze > $HOME/tmp/Analyze_$INGRES_SID.log 2>&1'
 
</pre>
 
</pre>
{{SQWareProductionSurchargeEtc|ingres|Ing|CrontabRef}}
 
 
<br>
 
<br>

Latest revision as of 22:29, 24 May 2011

Configuration file $gvsqw_IngBin/../etc/CrontabRef:



File content:


# Dump
00 20 * * * ksh -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Dump > $HOME/tmp/Dump_$INGRES_SID.log 2>&1'
# Optimize
00 04 * * 6 ksh -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Optimize > $HOME/tmp/Optimize_$INGRES_SID.log 2>&1'
# Analyze
00 05 * * 6 ksh -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Analyze > $HOME/tmp/Analyze_$INGRES_SID.log 2>&1'