News, views, tips and tricks on Oracle and other fun stuff

Five Features You Ought to Know About the Oracle Scheduler

I really enjoyed Kscope last week. It was educational, entertaining and social. Many thanks to ODTUG and the Oracle ACE program and to everyone who made it happen.

Check out Markus‘s awesome Flickr album to get a taste of how good the conference was, especially All Aboard The Queen Mary event. 🙂

My presentation went very well, judging from the postive feedback I got from the audience. Here is the paper that I submitted to Kscope:

Continue reading…

Comments Off on Five Features You Ought to Know About the Oracle Scheduler | Filed in Oracle | Tags: ,

Symposium Sunday at ODTUG Kscope 11

I am currently in Long Beach, California for the Kaleidoscope 2011 conference. I attended the Database Development Symposium today (Sunday), which Chet volunteered to put together. It was an all day event and it was great. Here is a very brief summary of the presentations:

Continue reading…

2 Comments | Filed in Oracle | Tags: ,

Where All Oracle Professionals Should Be Between June 26-30 2011

I'm speaking at ODTUG Kscope11

Kaleidoscope 2011, the Oracle Development Tools User Group‘s annual conference, is where you should be. It will be held in Long Beach, CA.

Register now to take advantage of 250+ technical sessions featuring top-notch speakers including 40+ Oracle ACEs.

I will be presenting about the Oracle Scheduler. Here are the details:

Title: Five Features You Ought to Know About the Oracle Scheduler (Abstract ID:239756)

Date and time: 06/29/2011, 11:15 AM-12:15 PM


DBMS_JOB was made available with Oracle 7.2 and has been superseded in 10g by the Oracle Scheduler. Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler.

In this session we will explore the following five Scheduler features that make the Oracle RDBMS the most powerful scheduling tool ever existed:

  1. Calendar: Use the rich calendaring syntax of the Scheduler to enable you to define simple and complex schedules.
  2. Chains: Implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.
  3. Resource Manager: Get the best out of your system by combining the Scheduler and the Resource Manager.
  4. Events: Learn how to schedule jobs based on events and how to listen and react to raised events.
  5. External jobs: Schedule jobs that run operating system executable that runs outside the database.

I will also be participating in an Oracle RDBMS Database Development panel in a Lunch and Learn session on Tuesday, June 28.

Looking forward to seeing you at ODTUG Kscope11.

Comments Off on Where All Oracle Professionals Should Be Between June 26-30 2011 | Filed in Oracle | Tags: ,

ODTUG KScope 11 and Database Content

Lewis Cunningham:

My plan was to build the conference around the life cycle that a database developer works with. Since we weren’t cherry picking the content we couldn’t force anything on the schedule but the overall goal was to present topics, from beginner to expert, on Design, Coding, Maintenance and Best Practices. You can get more on what I mean by those topics at the site. I really believe we met that goal. You can also see the schedule now.

Comments Off on ODTUG KScope 11 and Database Content | Filed in Links, Oracle | Tags: ,