I have a SQL job that assigns variable in the first step to check status of another job. If job not running, it continues to next step. That step executes a stored procedure that does not declare variables as part of the definition. But I'm getting this error when it gets to that step.
Procedure has no parameters and arguments were supplied. [SQLSTATE 42000] (Error 8146). The step failed.
I didn't think SQL job carried variables from one step to another, but is there a way to clear before proceeding to next step?