Voir la source de SQWareProduction:mssql:etc:sqwmsq ConfInst Jobs.cfg

Fichier de configuration $gvsqw_MsqBin/../etc/sqwmsq_ConfInst_Jobs.cfg:<br>
{{SQWareProduction_sqwmsq_ConfInst_Jobs.cfg_presentation}}
<br>
<br>
Contenu du fichier:
<pre>

#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
</pre>
<br>