SQWareProduction:ingres:etc:CrontabRef: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
m Updated by Expdbtools
 
m Updated by BatchUser
 
(One intermediate revision by the same user not shown)
Line 7: Line 7:


# Dump
# 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'
00 20 * * * bash -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Dump > $HOME/tmp/Dump_$INGRES_SID.log 2>&1'
# Optimize
# 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'
00 04 * * 6 bash -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Optimize > $HOME/tmp/Optimize_$INGRES_SID.log 2>&1'
# Analyze
# 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'
00 05 * * 6 bash -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 16:01, 23 February 2025

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



File content:


# Dump
00 20 * * * bash -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 bash -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 bash -c '. $HOME/.profile $INGRES_SID;$gvsqw_IngBin/sqwing_RunJob.ksh -I $INGRES_SID -A Analyze > $HOME/tmp/Analyze_$INGRES_SID.log 2>&1'