SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Configuration file $ | Configuration file $gvsqw_MsqBin/../etc/sqwmsq_ConfInst_Jobs.cfg:<br> | ||
{{SQWareProduction_sqwmsq_ConfInst_Jobs.cfg_presentation}} | {{SQWareProduction_sqwmsq_ConfInst_Jobs.cfg_presentation}} | ||
<br> | <br> | ||
| 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 | ||
#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: run failed backups from BackupAll | ||
BackupAllRep:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh - | BackupAllRep:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -REP -Exec | ||
#StatisticsAll : update statistics tables for all databases | #StatisticsAll : update statistics 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 | ||
#CheckdbAll : DBCC CheckDB for all databases | |||
CheckdbAll:$gvsqw_MsqBin/sqwmsq_CheckdbAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec | |||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 16:41, 2 July 2021
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