SQWareProduction:teradata:etc:sqwter CreInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 15:41, 4 May 2015 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Configuration file $gvsqw_TerBin/../etc/sqwter_CreInst_Jobs.cfg:



File content: 


#IndicDba: Gather DBAs indicators
IndicDba:$gvsqw_TerBin/sqwter_GatherIndicators.ksh -I <TER_SID>

#Dump: backup all databases with teradataDump
Dump:$gvsqw_TerBin/sqwter_DumpAllDatabases.ksh -I <TER_SID> -Exec

#Optimize : optimize tables for all databases
Optimize:$gvsqw_TerBin/sqwter_OptimizeAllDatabases.ksh -I <TER_SID> -Exec

#Analyse : analyze tables for all databases
Analyze:$gvsqw_TerBin/sqwter_AnalyzeAllDatabases.ksh -I <TER_SID> -Exec

#SlowQuery: Rotate log slow query
SlowQuery:$gvsqw_TerBin/sqwter_RotateLogSlowQuery.ksh -I <TER_SID>

#PurgeAlert: Rotate error log
PurgeAlert:$gvsqw_TerBin/sqwter_PurgeAlert.ksh -I <TER_SID>

#NetBackup: run user backup command
NetBackup:$gvsqw_TerBin/sqwter_NetBackup.ksh -I <TER_SID> -Policy <Policy> -Schedule  <Schedule> -Exec


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:teradata:etc:sqwter_CreInst_Jobs.cfg&oldid=6853"