SQL Agent Job reports that is succeeded. If I manually run the Stored Procedure, it works every time but it will not create the file when ran via the SQL Agent Job.
My user has rights to the folder as does the user used for SQL Agent Service and SQL Server Service.
Has anyone ran into this issue? Any ideas?