MS SQL server 2000 Job limit?

Is there a limit to how many jobs you can have total - or a limit on
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
AaronThe limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:

>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron