10.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 10-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.

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;