SET_MAX_SCHEDULER_JOBS Procedure

5.28 SET_MAX_SCHEDULER_JOBS Procedure

This procedure sets the application attribute "Maximum Scheduler Jobs."

This procedure also indicates how many scheduler jobs can run at the same time to execute background page processes.

Syntax

APEX_APPLICATION_ADMIN.SET_MAX_SCHEDULER_JOBS (
    p_application_id        IN NUMBER,
    p_max_scheduler_jobs    IN NUMBER )

Parameters

Table 5-2 SET_MAX_SCHEDULER_JOBS Parameters

Parameter	Description
`p_application_id`	The application ID.
`p_max_scheduler_jobs`	Maximum number of scheduler jobs running for this application at the same time.

Example

The following example sets the maximum scheduler jobs for app 100 to 5.

BEGIN
    apex_application_admin.set_max_scheduler_jobs(100, 5);
END;