I a have small bunch of jobs which are scheduled to run under a proxy account. For some reason, each night a random handful of those jobs fail with the following error:
Message
Unable to start execution of step 1 (reason: Error authenticating proxy LSP\JobUser, system error: Logon failure: unknown user name or bad password.). The step failed.
The jobs that fail are always random and if I manually run the job, EVERY one of them works fine.
The only thing different from this collection of jobs (about a dozen of them) and other jobs I have on the system (which have never gotten this error) are that the new dozen are all started at the same time (at 1:30am). Is it possible that SQL Agent cannot handle a dozen jobs at once Or at least cannot handle authenticating a dozen jobs at once
Any thoughts
Proxy Error
Rupesh Kumar
Update:
I modified the jobs so instead of starting at exactly the same time (1:30) they are staggered out over minute intervals (some start at 1:30, some at 1:31, a few more at 1:32, and so on) over a 7 or 8 minute period.
This resulted in all the jobs starting up WITHOUT errors.
So it seems that SQL Server Agent has trouble starting up more than a few jobs at once.