So I have a stored procedure that calls an AS400 Linked server. Now, the stored procedure will execute successfully. However, it is used in a SQL Agent Job and each time the job runs, it gives the
Linked Server has Run out of Memory exception.
Why does the fact that it is running in a job environment make it differ from running as the raw SQL code? And how would I go about solving/fixing this?