Job Frequency with DBMS_SCHEDULER and SQL Developer

thatjeffsmith SQL Developer 0 Comments

I was remarking to someone this morning how easy I thought it was to setup a job, say on the first and third Wednesday of the month. The flexibility of DBMS_SCHEDULER, even without taking into account the power of schedules, is really powerful. We have a scheduler wizard that puts a graphical user interface onto the DBMS_SCHEDULER package. Here’s how …

Average Run Time for Oracle Jobs

thatjeffsmith Database Stuff, SQL Developer 7 Comments

Starting with 10g and the introduction of DMBS_SCHEDULER, Oracle database began tracking and storing the execution duration of a job. By default this information is kept around for 30 days. You can of course change the logging level and the retention period for the job runs – read the docs! The job runs can be viewed via the dba_scheduler_job_run_details SYS …

My New Gig

thatjeffsmith General 5 Comments

The good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary database development tool. This is …

Toad Jobs

thatjeffsmith Toad® Stuff (Retired) 0 Comments

A lot of good news this week about jobs here in the United States and a bunch of new hires for the month of April has many people feeling much better about the US economy. After being hammered with depressing reports for the past two years, it’s very nice to see the pendulum swing in the other direction. Quest has …