Oracle Scheduled job not running as per schedule.

Tags
programming

 
Thread Tools Search this Thread
# 1  
Old 08-29-2011
Oracle Scheduled job not running as per schedule.

Hi,
Though this is a unix forum mainly, am posting this oracle query here hoping to get a resolution.

I have set up two scheduled jobs in oracle 11g for executiong a procedure in specific time intervals. One as Hourly and other as minutely.
But the scheduled jobs are not running as per schedule. i.e the minutely job is not running every minute. But If i see the run logs for some period it would have run every minute, and suddenly it will not execute and give a gap of 30 mins or 1 hour and then run again.

Have attached the script for the scheduler and the run logs for the minutely job. Please advice what can be done.

P.s. The job priority is set as 3. and except for these two jobs there are no other jobs set. But this is an important job which needs to be run every minute.
# 2  
Old 08-29-2011
What is the setting of JOB_QUEUE_PROCESSES and what's the maximum number of concurrently running jobs?
# 3  
Old 08-30-2011
Oracle Scheduled job not running as per schedule.

JOB_QUEUE_PROCESSES is set to 1000, which is max. And there are only 3 scheduled jobs in the whole DB.

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Scheduled job not running automatically in crontab Santhosh CJ Shell Programming and Scripting 6 03-12-2015 08:15 AM
schedule a job without Cron pravin27 Shell Programming and Scripting 1 02-16-2012 10:40 PM
run unix script as scheduled job vignesh53 Shell Programming and Scripting 2 01-12-2012 11:21 AM
schedule job j_panky Shell Programming and Scripting 4 10-20-2011 11:38 AM
Schedule a corn job ch33ry UNIX for Dummies Questions & Answers 3 08-10-2011 05:28 PM
Schedule a Cron job ch33ry Shell Programming and Scripting 0 08-10-2011 04:20 PM
Schedule Job udtyuvaraj AIX 1 07-27-2010 06:31 AM
Schedule a job using Crontab jatanig Shell Programming and Scripting 1 03-15-2010 10:45 AM
max os x .plist not running as scheduled? Movomito UNIX for Dummies Questions & Answers 0 12-08-2008 12:00 PM
Scheduled job blackeyed UNIX for Dummies Questions & Answers 1 07-10-2008 01:00 PM
problem when the script is scheduled to run as cron job forumthreads UNIX for Dummies Questions & Answers 6 07-19-2007 01:27 PM
Jobs scheduled in crontabs are not running after a migration to oracle 9i alexcol UNIX for Advanced & Expert Users 4 03-27-2007 11:35 PM
How to schedule a job ashvik UNIX for Advanced & Expert Users 5 09-22-2005 08:53 AM
Conditional File Movement script scheduled using CRON job imu Shell Programming and Scripting 2 09-20-2005 07:30 AM
AT job scheduled exactly 2 hours late bohunk24 UNIX for Dummies Questions & Answers 10 08-04-2005 06:48 PM