SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 18:33, 5 April 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search

Configuration file $gvsqw_MssBin/../etc/sqwmsq_ConfInst_Jobs.cfg:



File content:


#IndicDba: Gather DBAs indicators
IndicDba:$gvsqw_MsqBin/sqwmsq_GatherIndicators.ksh -I <lvsqw_InstanceParam>

#RotateErrorLog: Rotate error log
RotateErrorLog:$gvsqw_MsqBin/sqwmsq_RotateErrorLog.ksh -I <lvsqw_InstanceParam> -Exec

#BackupAll: backup all databases
BackupAll:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec

#BackupAllRep: run failed backups from BackupAll
BackupAllRep:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -REP -Exec

#StatisticsAll : update Statisticsistics tables for all databases
StatisticsAll:$gvsqw_MsqBin/sqwmsq_StatisticsAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec

#RebuildAll : Rebuild indexes tables for all databases
RebuildAll:$gvsqw_MsqBin/sqwmsq_RebuildIndexAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec

#RestoreParfile : restore list of databases content in parfile
RestoreParfile:$gvsqw_MsqBin/sqwmsq_RestoreAllDatabases.ksh -I <lvsqw_InstanceParam> -PAR $Parfile -Exec