asked
SQL agent job not deleting a file via ssis
Dear All, I have a SSIS package that deletes older log files from a location. The logic is based on modified date. It works fine when it is executed manually but when it is scheduled via a SQL Server Agent job, it doesn't deletes the files at specified location. The job terminates successfully and there are no errors displayed. Any help in this regard would be very helpful. Regards, Rafayz
You need to make sure that the account that SQL Server Agent is using has rights to be able to delete the files. When you execute manually it is using your credentials. When executed by SQL Server Agent it uses the service account of SQL Server Agent.
Tim can you kindly tell me how to change sql server agent accounts setting?? I am new to SQL server agent. Help in this regard will be appreciated. Regards, Rafayz
You can find information about account under which the agent is running in the SQL Server Configuration Manager. Then you can grant that account appropriate rights. Also you have possibility to change account to other one if necessary. If the files are located on remote machine, then agent has to be running under account which has access to that remote machine. In most cases a domain account with appropriate rights.
One of the options As @Tim mentioned is grant the service account under which the agent is running appropriate rights to be able to delete those files. The other option is to create a **proxy account** with appropriate rights and specify the proxy account in the job. So the Agent executes the SSIS under this specific proxy account with all the necessary rights for the delete operation.
9 People are following this question.
