SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg
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