SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
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 18: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