To display existing scheduler windows, you should query the “dba_scheduler_windows” table:
In my case, I needed to disable a window, so that it doesn’t run any scheduled jobs, so I had to run the following:
DBMS_SCHEDULER.DISABLE (NAME => ‘SYS.MY_WINDOW‘,
FORCE => TRUE);
For a complete reference for managing the scheduler, this link contains everything you need:
Important note: In order to be able to run the above procedure, you have to be granted the “manage scheduler” privilege, e.g.
“grant manage scheduler to user_name;”