Viewing 6 posts - 1 through 6 (of 6 total)
Phill, Thanks for your replies.
I've tried both EM and sp_start_job from QA when I have 8 jobs running. Neither method will start a ninth job.
In each step of the...
July 16, 2007 at 6:32 am
Windows Server 2003
SQL Server 2000 Enterprise with SP4
There is a master job which is scheduled, it has steps that start jobs using sp_start_job.
Trying to start the jobs manually gives the...
July 16, 2007 at 6:05 am
Thanks Phil. I found that, too, but it references the same MS article. I've quadrupled the parameters in the registry discussed by the article, and still am limited...
July 13, 2007 at 10:24 am
The article specifies Worker Threads, but not, specifically, SQL Jobs. Using the article, I increased the threads, and still have the same problem. What is more confusing is...
July 13, 2007 at 8:15 am
Found it. For anyone else who may be interested...
' Add the input parameter and set its properties.
Command.Parameters.Add("@SKU", SqlDbType.VarChar).Value = SKU
Command.Parameters.Add("@Price", SqlDbType.Float).Value...
May 9, 2007 at 6:20 am
This works great, but what about the direction? Does it not have to be specified?
May 8, 2007 at 8:14 am
Viewing 6 posts - 1 through 6 (of 6 total)