Oracle Scheduled job not running as per schedule.


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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  
What is the setting of JOB_QUEUE_PROCESSES and what's the maximum number of concurrently running jobs?
# 3  
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.
Login or Register to Reply

|
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
i have a job scheduled in crontab. The problem is, it is not running automatically as per the time scheduled. But runs when executed manually. What would be the problem? Help me with this please.... Shell Programming and Scripting
6
Shell Programming and Scripting
run unix script as scheduled job
vignesh53
Hi, I want my unix script to run as a scheduled job such that the script is invoked once every 15 minutes. Is there any way to achieve this other than running the script as a cron job?... Shell Programming and Scripting
2
Shell Programming and Scripting
Scheduled job
blackeyed
I have a lot of jobs scheduled using at command. at -l gives only the job names and time ... how do i know which script is associated with which jobid. Thanks.... UNIX for Dummies Questions & Answers
1
UNIX for Dummies Questions & Answers
Jobs scheduled in crontabs are not running after a migration to oracle 9i
alexcol
Good Morning. The problem started after tha migration to a newer version of oracle - migration to oracle 9i. Before the migration jobs that were scheduled in crontabs were running ok. but after the migration they are not running. I understand that is not easy to find out what the problem is....... UNIX for Advanced & Expert Users
4
UNIX for Advanced & Expert Users
AT job scheduled exactly 2 hours late
bohunk24
This occurs on an i386 box running Unix System V/386 Release 4.2 Ver 1.1.2. I have an 'at' scheduling anomaly whose behavior I am trying to understand. On one particular system, when an 'at' job is submitted, the time the job is actually scheduled to run is exactly 2 hours later than what the...... UNIX for Dummies Questions & Answers
10
UNIX for Dummies Questions & Answers