SQWareProduction:ingres:etc:sqwing Jobs.cfg

From Wiki_dbSQWare
Jump to: navigation, search

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 Statisticss 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