Change to job scheduler tasks Configuration Parameter

The default value for configuration parameter job scheduler tasks has been changed to 4 in Adaptive Server 15.5 ESD #1 and later versions.

However, for compatibility with RAP - The Trading Edition R4, you must set job scheduler tasks to 32 using:

sp_configure "job scheduler tasks", 32

If you change the default value of the job scheduler tasks, you may also need to increase the number of user connections in the Adaptive Server by twice the value of job scheduler tasks. If the same Adaptive Server hosts the Job Scheduler and the jobs, you may need to increase number of user connections in the Adaptive Server by three times the value of job scheduler tasks. If you increase the number of user connections, you may need to increase max memory in the Adaptive Server.

Note: If you set the value of job scheduler tasks to "default" before you upgrade Adaptive Server, the server automatically sets the new default to 4.

If the initial value of number of user connections is 50, and you want to set job scheduler tasks to 10, increase number of user connections by 2*10 and set the parameter to 50+20 = 70. If the Job Scheduler is running on the same server, increase number of user connections by 3*10 and set the parameter to 50+30 = 80.