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?
Question
IFS8 - problem with scheduled tasks after transferring the database
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.