Difference between revisions of "SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 7: | Line 7: | ||
#IndicDba: Gather DBAs indicators | #IndicDba: Gather DBAs indicators | ||
| − | IndicDba:$gvsqw_MsqBin/sqwmsq_GatherIndicators.ksh - | + | IndicDba:$gvsqw_MsqBin/sqwmsq_GatherIndicators.ksh -I <lvsqw_InstanceParam> |
#RotateErrorLog: Rotate error log | #RotateErrorLog: Rotate error log | ||
| − | RotateErrorLog:$gvsqw_MsqBin/sqwmsq_RotateErrorLog.ksh - | + | RotateErrorLog:$gvsqw_MsqBin/sqwmsq_RotateErrorLog.ksh -I <lvsqw_InstanceParam> -Exec |
#BackupAll: backup all databases | #BackupAll: backup all databases | ||
| − | BackupAll:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh - | + | BackupAll:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec |
#BackupAllRep: run failed backups from BackupAll | #BackupAllRep: run failed backups from BackupAll | ||
| − | BackupAllRep:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh - | + | BackupAllRep:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -REP -Exec |
| − | #StatisticsAll : update | + | #StatisticsAll : update Statisticsistics tables for all databases |
| − | StatisticsAll:$gvsqw_MsqBin/sqwmsq_StatisticsAllDatabases.ksh - | + | StatisticsAll:$gvsqw_MsqBin/sqwmsq_StatisticsAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec |
| − | #RebuildAll : | + | #RebuildAll : Rebuild indexes tables for all databases |
| − | RebuildAll:$gvsqw_MsqBin/sqwmsq_RebuildIndexAllDatabases.ksh - | + | RebuildAll:$gvsqw_MsqBin/sqwmsq_RebuildIndexAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec |
#RestoreParfile : restore list of databases content in parfile | #RestoreParfile : restore list of databases content in parfile | ||
| − | RestoreParfile:$gvsqw_MsqBin/sqwmsq_RestoreAllDatabases.ksh - | + | RestoreParfile:$gvsqw_MsqBin/sqwmsq_RestoreAllDatabases.ksh -I <lvsqw_InstanceParam> -PAR $Parfile -Exec |
</pre> | </pre> | ||
<br> | <br> | ||
Revision as of 18:33, 5 April 2014
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
