AM_DROP_TASK procedure - Delete a monitoring task

The AM_DROP_TASK procedure deletes a monitoring task. It does not return any data.

Syntax

Important: The related activity monitor routines is deprecated and might be removed in a future release. For more information, see Activity monitor routines have been deprecated.
Read syntax diagramSkip visual syntax diagramAM_DROP_TASK(task_id)

The schema is SYSPROC.

Procedure parameter

task_id
An input argument of type INTEGER that specifies a unique monitoring task ID.

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the procedure is automatically created.

Example

Drop the monitoring task with ID 5. 
CALL SYSPROC.AM_DROP_TASK(5)