SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | ||
#NetBackup: run user backup command | |||
NetBackup:$gvsqw_SybBin/sqwsyb_NetBackup.ksh -I <lvsqw_Dataserver> -Policy <Policy> -Schedule <Schedule> -Exec | |||
#RsyncBackup: run rsync command | |||
RsyncBackup:$gvsqw_SybBin/sqwsyb_RsyncBackup.ksh -I <lvsqw_Dataserver> -Exec | |||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 16:49, 23 December 2016
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 #NetBackup: run user backup command NetBackup:$gvsqw_SybBin/sqwsyb_NetBackup.ksh -I <lvsqw_Dataserver> -Policy <Policy> -Schedule <Schedule> -Exec #RsyncBackup: run rsync command RsyncBackup:$gvsqw_SybBin/sqwsyb_RsyncBackup.ksh -I <lvsqw_Dataserver> -Exec