SQL Server Agent - 12-20-2005 , 01:45 PM
SQL 2k SP3a
There are 930 agent jobs scheduled. The Next Run Date value is no longer
being displayed however, jobs seem to run. Is there a limit for the number of
jobs SQL Server Agent will handle?
Re: SQL Server Agent - 12-20-2005 , 09:22 PM
You more often hit issues with the number of concurrent jobs
that will run but you can hit different issue with a large
number of jobs in SQL 2000.
This isn't an issue in SQL Server 2005 that I've seen and
you also have more options with the additional services.
In SQL 2000, the only way I know of to work around some of
those limits is to write your own job scheduler program.
On Tue, 20 Dec 2005 11:45:02 -0800, "FredG"
<FredG (AT) discussions (DOT) microsoft.com> wrote:
Re: SQL Server Agent - 12-21-2005 , 07:00 AM
Our best pracitices is not to utilize SQL Server as an User Scheduler.
Howerver, since this is a third-party vendor application we don't have any
control over it. We are just stuck supporting it.
"Sue Hoegemeier" wrote: