SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 22:29, 24 May 2011 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 -S <lvsqw_InstanceParam>

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

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

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

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

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

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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:etc:sqwmsq_ConfInst_Jobs.cfg&oldid=1962"