Scheduled Jobs-Can you have too many?

[BobH]

I'm thinking of using the SQL Agent Job Scheduler as part of a larger application and I'm wondering if anyone knows of a limit on how many schedules or jobs that can exist on a SQL Server at one time.

Thanks!

[Gary Andrews]

Short answer, I know of no limit.

However there are a multiude of variables which affect your answer.

i.e.
How much memory is available.
How many processors are available.
How fast are the processors.
How much L2 cache is available to the processors.
How many applications are you running concurrently on the server. This means: services, long running applications (like 24x7), and miscellaneously submitted batch jobs.
Are you using SCSI disks and SCSI disk controllers or something else.
Are you using cache in the disk controllers.
How CPU intensive is each application you are executing.
If using NTFS, is it being compressed or is it non-compressed.
Is data stored locally, or on a network drive. If on a network drive, then a host of network issues may affect job limit.

While this may not be the answer you are looking for, I hope it helps put the question into perspective.

Gary A.




------------
BobH at 7/27/01 1:24:43 PM

I'm thinking of using the SQL Agent Job Scheduler as part of a larger application and I'm wondering if anyone knows of a limit on how many schedules or jobs that can exist on a SQL Server at one time.

Thanks!