SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Ligne 14 : | Ligne 14 : | ||
#BackupAll: backup all databases | #BackupAll: backup all databases | ||
BackupAll:$gvsqw_MsqBin/sqwmsq_BackupAllDatabases.ksh -I <lvsqw_InstanceParam> -Exec | 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 | ||
Version actuelle datée du 2 juillet 2021 à 15:36
Fichier de configuration $gvsqw_MsqBin/../etc/sqwmsq_ConfInst_Jobs.cfg:
Contenu du fichier:
#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
