Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

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!

About SoCRaT

Software Engineer, OSS & Linux Geek
This entry was posted in Oracle and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s