job scheduler tasks

Summary information

Default value

4

Range of values

1 – 640

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

SQL Server Administration

job scheduler tasks sets the maximum number of jobs that can run simultaneously through Job Scheduler.

NoteIf you increase the value of job scheduler tasks to a higher value, you must increase the value for number of user connections by at least twice the value you incremented job scheduler tasks before starting the Job Scheduler.

However, if the Adaptive Server running the scheduled jobs is the same Adaptive Server that is hosting the Job Scheduler, you must increase the value for number of user connections by three times the value you incremented job scheduler tasks before starting the Job Scheduler.

Increasing the number of user connections may require that you increase the value for max memory.