SQWareProduction:sybase:etc:sqwsyb CreDs Jobs.cfg

From Wiki_dbSQWare
Revision as of 18:04, 5 October 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search

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