Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 21: | Line 21: | ||
Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | Reorg:$gvsqw_SybBin/sqwsyb_RebuildAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | ||
| − | #UpdateStats: Update | + | #UpdateStats: Update statistics all databases |
UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | ||
| − | #UpdtStats: Update index | + | #UpdtStats: Update index statistics all databases |
UpdtStats:$gvsqw_SybBin/sqwsyb_UpdtStatsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | UpdtStats:$gvsqw_SybBin/sqwsyb_UpdtStatsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | ||
| Line 30: | Line 30: | ||
Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | Dbcc:$gvsqw_SybBin/sqwsyb_DbccAllDatabases.ksh -I <lvsqw_Dataserver> -Exec | ||
| − | #UpdtStatsRebuildWithFlag: Wait flag + Update index | + | #UpdtStatsRebuildWithFlag: Wait flag + Update index statistics all databases + Reorg all databases |
UpdtStatsRebuildWithFlag:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -Flag filename -SshConn usr@host -Exec | UpdtStatsRebuildWithFlag:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -Flag filename -SshConn usr@host -Exec | ||
| − | #UpdtStatsRebuild: Update index | + | #UpdtStatsRebuild: Update index statistics all databases + Reorg all databases |
UpdtStatsRebuild:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -NoWaitFlag -Exec | UpdtStatsRebuild:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -NoWaitFlag -Exec | ||
</pre> | </pre> | ||
<br> | <br> | ||
Revision as of 20:22, 16 June 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 statistics all databases UpdateStats:$gvsqw_SybBin/sqwsyb_StatisticsAllDatabases.ksh -I <lvsqw_Dataserver> -Exec #UpdtStats: Update index statistics 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 statistics all databases + Reorg all databases UpdtStatsRebuildWithFlag:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -Flag filename -SshConn usr@host -Exec #UpdtStatsRebuild: Update index statistics all databases + Reorg all databases UpdtStatsRebuild:$gvsqw_SybBin/sqwsyb_UpdtStatsRebuildWithFlag.ksh -I <lvsqw_Dataserver> -NoWaitFlag -Exec
