To display existing scheduler windows, you should query the “dba_scheduler_windows” table:

e.g.

SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED
FROM dba_scheduler_windows

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:

BEGIN
DBMS_SCHEDULER.DISABLE (NAME => ‘SYS.MY_WINDOW‘,
FORCE => TRUE);
END;

For a complete reference for managing the scheduler, this link contains everything you need:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/tasks004.htm

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;”

Enjoy!