|
Home > Archive > MS SQL Server > December 2006 > setting the number of jobs executed in parallel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Uri Dimant 2006-12-13, 5:18 am |
| 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
| |
| Tibor Karaszi 2006-12-13, 5:18 am |
| 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
erverAgent\Subsystem
s
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...
> 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 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
erverAgent\Subsystem
s
>
> 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...
>
>
>
| |
|
|
|
|
|