scheduler_state 
You display whether the scheduler function is activated or deactivated.
Prerequisites
You have the server authorization SchedulerMgm or Scheduling.
Structure
scheduler_state
Result
OK
<state>
Value |
Description |
|---|---|
<state> |
Scheduler function, possible values are: ON | OFF ON: the Scheduler is running and active Scheduler jobs are executed. OFF: the Scheduler is deactivated |
Example
Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display the scheduler function:
>dbmcli -u OLEG,MONDAY -d DEMODB scheduler_state
OK
ON
More Information
Database Administration, Automating Administration Tasks