I have a SQL agent job that selects from a table and using the advanced options I can send the results to a test file. It works fine. But I'd like to send the file to a different server and am getting an error: "Executed as user: MGH\sqlagent. Unable to open Step output file. The step succeeded."
I added permission for the sql agent service account on the other server. I'm using output path like: \\servername\foldername\filename.txt
Is that syntax correct? Am I missing some permission on the other server?
Thanks very much for any help.