9.11 IS_RUNNING Function

This function determines whether a given automation is currently running.

Syntax

APEX_AUTOMATION.IS_RUNNING (
    p_application_id    IN NUMBER   DEFAULT {current application id},
    p_static_id         IN VARCHAR2 )
    RETURN BOOLEAN;

Parameters

Table 9-3 IS_RUNNING Parameters

Parameter	Description
p_application_id	ID of the application which contains the automation.
p_static_id	Static ID of the automation to disable.

Returns

If TRUE, the automation is currently running.

Example

The following example prints out whether the automation is currently running.

BEGIN
IF apex_automation.is_running(
p_application_id => 152,
p_static_id => 'my_emp_table_automation' )
THEN
dbms_output.put_line( 'The Automation is currently running.' );
ELSE
dbms_output.put_line( 'The Automation is currently not running.' );
END IF;
END;