1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Drop Trigger Spool

Drop Trigger Spool

The MaxL drop trigger_spool statement helps you delete the log file created by an Essbase trigger.

Triggers track state changes over a selected cube area. For more information about triggers, see Examples of Triggers.

Syntax


Description of drptrigspool.gif follows
Description of the illustration drptrigspool.gif

Keywords

You can delete trigger log files following ways using MaxL drop trigger_spool.

drop trigger_spool SPOOL-NAME

Delete the spool file by name.

Example:

drop trigger_spool Sample.Basic.spoolfile;
drop trigger_spool all on database DBS-NAME

Delete all the spool files on a specific cube.

Example:

drop trigger_spool all on database Sample.Basic;