I am trying to run a scheduled job in SQL and the job fails. I am at a lost of how to fix the error.
Here is the error I get...
"NT AUTHORITY\SYSTEM. Load job is already running... [SQLSTATE 42000] (Error 50000). The step failed."
Any help would be great
Thanks,
Jeff
Hi Jeff,
Have you tried restarting the SQL Server Agent service? It doesn't happen often, but I've seen a restart of that service clear up strange errors like this before.
Thanks,David