SPROC runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent
- by jim-johnston
I have a stored procedure that runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent. It just spins.
I have checked permissions, ANSI NULL ON , etc. to no avail. Funny thing is I can wrap a SSIS package around it and then run it from a Agent Job and it works.
Any ideas?
Thanks in advance
V/R Jim