How Do I Grant Access To Sql Server Agent To Be Able To Write/modify System Files?

I have a job that has a stored procedure that runs BCP to QUERYOUT some data. If I run the QUERYOUT command by itself, it works. However, if I try to run it in a JOB, it creates th

Solution 1:

check what user is assigned to SQL Server Agent service. Open services.msc, locate the SQL Server Agent and check Logon properties. There will be either a LocalSystem user (unlikely, based on what you have described) or another user.

Check that the user has "Write" access to the folder where you are trying to write the BCP dump.