I've tried it with a global temp table, and still no luck.

As an alternative, I took out the insert statement from my stored procedure, and set it as a new step in SQL job.

Thank you both, Phil and Sue!