SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg

From Wiki_dbSQWare
Jump to: navigation, search

Configuration file $gvsqw_MsqBin/../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

#BackupAllLog: backup "logs" for all databases
BackupAllLog:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -Type log -ID xx,yy -Exec

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

#StatisticsAll : update statistics 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

#CheckdbAll : DBCC CheckDB for all databases
CheckdbAll:$gvsqw_MsqBin/sqwmsq_CheckdbAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec