MonitorAnalyzeSP monitors the progress of the AnalyzeSP associated with a given action list.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
CALL [TDMaps.] MonitorAnalyzeSP ( 'ActionListName', :CompleteSteps, :TotalSteps ) [;]
Syntax Elements
- TDMaps.
- The name of the database.
- ActionListName
- Name of the analyzed action list.
- CompleteSteps
- An output parameter for the number of steps that the Analyzer finished analyzing.
- TotalSteps
- An output parameter for the total number of steps completed during analysis.