Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 7: | Line 7: | ||
#IndicDba: Gather indicators DBAs | #IndicDba: Gather indicators DBAs | ||
| − | IndicDba:$gvsqw_SybBin/sqwsyb_GatherIndicators.ksh - | + | IndicDba:$gvsqw_SybBin/sqwsyb_GatherIndicators.ksh -I <lvsqw_Dataserver> |
#DumpFull: Dump full all databases | #DumpFull: Dump full all databases | ||
| − | DumpFull:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh - | + | DumpFull:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -I <lvsqw_Dataserver> -Type full -Exec |
#DumpInc: Dump tran | #DumpInc: Dump tran | ||
| − | DumpInc:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh - | + | DumpInc:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -I <lvsqw_Dataserver> -ID mydblist -Type inc -Exec |
#Checkstorage: Checkstorage all databases | #Checkstorage: Checkstorage all databases | ||
| − | Checkstorage:$gvsqw_SybBin/sqwsyb_CheckstorageAllDatabases.ksh - | + | Checkstorage:$gvsqw_SybBin/sqwsyb_CheckstorageAllDatabases.ksh -I <lvsqw_Dataserver> -Exec |
#Reorg: Reorg all databases | #Reorg: Reorg all databases | ||
| − | Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh - | + | Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh -I <lvsqw_Dataserver> -Exec |
| − | #UpdateStats: Update | + | #UpdateStats: Update Statisticsistics all databases |
| − | UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh - | + | UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec |
| + | |||
| + | #UpdtStats: Update index Statisticsistics all databases | ||
| + | UpdtStats:$gvsqw_SybBin/sqwsyb_UpdtStatsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | ||
#Dbcc: Dbcc all databases | #Dbcc: Dbcc all databases | ||
| − | Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh - | + | Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -I <lvsqw_Dataserver> -Exec |
| + | |||
| + | #UpdtStatsRebuildWithFlag: Wait flag + Update index Statisticsistics all databases + Reorg all databases | ||
| + | UpdtStatsRebuildWithFlag:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -Flag filename -SshConn usr@host -Exec | ||
| + | |||
| + | #UpdtStatsRebuild: Update index Statisticsistics all databases + Reorg all databases | ||
| + | UpdtStatsRebuild:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -NoWaitFlag -Exec | ||
| + | |||
</pre> | </pre> | ||
<br> | <br> | ||
Revision as of 17:35, 5 April 2014
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_Jobs.cfg:
File content:
#IndicDba: Gather indicators DBAs IndicDba:$gvsqw_SybBin/sqwsyb_GatherIndicators.ksh -I <lvsqw_Dataserver> #DumpFull: Dump full all databases DumpFull:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -I <lvsqw_Dataserver> -Type full -Exec #DumpInc: Dump tran DumpInc:$gvsqw_SybBin/sqwsyb_DumpAllDatabases.ksh -I <lvsqw_Dataserver> -ID mydblist -Type inc -Exec #Checkstorage: Checkstorage all databases Checkstorage:$gvsqw_SybBin/sqwsyb_CheckstorageAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #Reorg: Reorg all databases Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #UpdateStats: Update Statisticsistics all databases UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #UpdtStats: Update index Statisticsistics all databases UpdtStats:$gvsqw_SybBin/sqwsyb_UpdtStatsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #Dbcc: Dbcc all databases Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #UpdtStatsRebuildWithFlag: Wait flag + Update index Statisticsistics all databases + Reorg all databases UpdtStatsRebuildWithFlag:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -Flag filename -SshConn usr@host -Exec #UpdtStatsRebuild: Update index Statisticsistics all databases + Reorg all databases UpdtStatsRebuild:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -NoWaitFlag -Exec
