setting the number of jobs executed in parallel

Hey All
is there a way to set the number of jobs being executed in parallel?
Is there a limit here?
I am using sql server 2000 sp3 on a windows 2000 server.
Thanks
Rea

Rea
Have you tried to assign the same scheduler to the jobs?



"Rea" <Rea@discussions.microsoft.com> wrote in message
news:E2CF9950-7869-4DE2-99EC- 835EEA6BF576@microso
ft.com...
> Hey All
> is there a way to set the number of jobs being executed in parallel?
> Is there a limit here?
> I am using sql server 2000 sp3 on a windows 2000 server.
> Thanks
> Rea

I believe you can. I don't think it is supported, so you would do it at your
 own risk, and it
involved direct modifications to the registry. I have a 2000 instance named 
SS2000I1, and for that I
have below registry path:

 HKEY_LOCAL_MACHINE\S
 OFTWARE\Microsoft\Mi
crosoft SQL  Server\SS2000I1\SQLS
erve
rAgent\Subsystems

In here, you find one entry per subsystem. You can edit that entry; at the e
nd you find the number
of concurrent threads the subsystem will run.

Above is from memory, and, again, if you don't find this documented you do i
t at your own risk.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Rea" <Rea@discussions.microsoft.com> wrote in message
news:E2CF9950-7869-4DE2-99EC- 835EEA6BF576@microso
ft.com...
> Hey All
> is there a way to set the number of jobs being executed in parallel?
> Is there a limit here?
> I am using sql server 2000 sp3 on a windows 2000 server.
> Thanks
> Rea

You are right!
here is the link to microsoft's documentation:
http://support.microsoft.com/kb/306457


"Tibor Karaszi" wrote:

> I believe you can. I don't think it is supported, so you would do it at yo
ur own risk, and it
> involved direct modifications to the registry. I have a 2000 instance name
d SS2000I1, and for that I
> have below registry path:
>
>  HKEY_LOCAL_MACHINE\S
 OFTWARE\Microsoft\Mi
crosoft SQL  Server\SS2000I1\SQLS
er
verAgent\Subsystems
>
> In here, you find one entry per subsystem. You can edit that entry; at the
 end you find the number
> of concurrent threads the subsystem will run.
>
> Above is from memory, and, again, if you don't find this documented you do
 it at your own risk.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Rea" <Rea@discussions.microsoft.com> wrote in message
> news:E2CF9950-7869-4DE2-99EC- 835EEA6BF576@microso
ft.com... 
>
>
>

Thanks for the link.

I didn't read the KB very closely, but assuming the KB doesn't state otherwi
se, it should be
supported (as it is mentioned in a KB article).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Rea" <Rea@discussions.microsoft.com> wrote in message
news:34396A2D-6F4C-4A0E-BFB6- 29BA7A48260F@microso
ft.com...
> You are right!
> here is the link to microsoft's documentation:
> http://support.microsoft.com/kb/306457
>
>
> "Tibor Karaszi" wrote:
>