January 8, 2025 at 4:01 pm
I have an issue when a stored procedure is executed from the SQL Server Agent it fails with the error, "Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)." However, I can execute it locally in Management Studio just fine. I've scoured various resources about the error and behavior between the agent versus management studio but I'm not coming up with anything. I know my post doesn't contain much information but I'm taking a shot in the dark hoping someone has either experienced something similar or can point me in the direction of additional things to help troubleshoot.
January 8, 2025 at 4:14 pm
But other procs execute ok?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 8, 2025 at 4:51 pm
All other procs are fine. That's what is making this extra difficult. The proc completes locally within a few minutes so it's not an overly long-running proc too.
January 8, 2025 at 11:23 pm
is that proc using a linked server by anychance? that would be a possible reason for that issue (associated with incorrect/invalid credentials for the sql job account)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply