Difference between revisions of "SQWareProduction:ingres:etc:sqwing Jobs.cfg"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| Line 36: | Line 36: | ||
ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec | ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec | ||
</pre> | </pre> | ||
| − | |||
<br> | <br> | ||
Revision as of 21:29, 24 May 2011
Configuration file $gvsqw_IngBin/../etc/sqwing_Jobs.cfg:
File content:
#IndicDba: Gather DBAs indicators IndicDba:$gvsqw_IngBin/sqwing_GatherIndicators.ksh -I $INGRES_SID #CheckInd: Check des indicateurs DBAs CheckInd:$gvsqw_IngBin/sqwing_CheckIndicators.ksh -I $INGRES_SID #CkpdbFull: ckpdb (full) for all databases CkpdbFull:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Exec #BckJnl: backup journal files for all databases BckJnl:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Jnl -Exec #Stats : update stats tables for all databases Stats:$gvsqw_IngBin/sqwing_OptimizeAllDatabases.ksh -I $INGRES_SID -Exec #Reorg : reorg tables for all databases Reorg:$gvsqw_IngBin/sqwing_UsermodAllDatabases.ksh -I $INGRES_SID -Exec #DbmsClose: close of all dbms DbmsClose:$gvsqw_IngBin/../tools/sqwing_DbmsClose.ksh #DbmsOpen: open of all dbms DbmsOpen:$gvsqw_IngBin/../tools/sqwing_DbmsOpen.ksh #KillSessions: kill of all sessions for all databases KillSessions:$gvsqw_IngBin/../tools/sqwing_KillSessions.ksh #ExportFull: Export Full for all databases ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec
