Skip to main content

Hi,

after transferring the database from Windows to Linux and enabling jobs, scheduled tasks do not run. Restarting the batchserver does not help, nor does re-enabling queues. Has anyone had a similar problem?

Have you made sure you have a non zero amount of database processes available for the schedules to run ?

 

If you run this query: select value from v$parameter where name = 'job_queue_processes'

 

What is the result ? If it’s zero, that’s why you’re noticing this behavior.

 

In which case, you can run this statement as an example to set 20 job_queue_processes to be available to be ran by the scheduler etc.

 

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20

 

(Note that you’ll need a highly privileged user to run these two statements, such as ifsapp. Ifsadmin won’t be able to run this)

Reply


Terms & ConditionsCookie settings