Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
Line 27: Line 27:
 
Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -S <lvsqw_Dataserver> -Exec
 
Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -S <lvsqw_Dataserver> -Exec
 
</pre>
 
</pre>
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_Jobs.cfg}}
 
 
<br>
 
<br>

Revision as of 22:30, 24 May 2011

Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_Jobs.cfg:



File content:


#IndicDba: Gather indicators DBAs
IndicDba:$gvsqw_SybBin/sqwsyb_GatherIndicators.ksh -S <lvsqw_Dataserver>

#DumpFull: Dump full all databases
DumpFull:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -S <lvsqw_Dataserver> -Type full -Exec

#DumpInc: Dump tran
DumpInc:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -S <lvsqw_Dataserver> -ID mydblist -Type inc -Exec

#Checkstorage: Checkstorage all databases
Checkstorage:$gvsqw_SybBin/sqwsyb_CheckstorageAllDatabases.ksh -S <lvsqw_Dataserver> -Exec

#Reorg: Reorg all databases
Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh -S <lvsqw_Dataserver> -Exec

#UpdateStats: Update statistics all databases
UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -S <lvsqw_Dataserver> -Exec

#Dbcc: Dbcc all databases
Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -S <lvsqw_Dataserver> -Exec