Delete a file running a SQL Agent job - What a complication - Possible?

• Pablo Campanini-336244

  SSC Eights!

  Points: 823

  More actions

  January 4, 2013 at 9:01 am

  #272509

  Hello:

  Something so simple to do manually "delete c:\Temp\MyFile.txt", I can not set to run in a SQL Server 2008 Job!!!!!!!!!!!!!!

  I tried many things, like create a Store Procedure, could not make it work.

  Also get the famous "xp_cmdshell" configuration set to 1.

  Why Microsoft had to complicate things? Maybe get a better scheduler in the OS Windows will help? because the Task scheduler is not very reliable.

  Just fustrated.... any help will be appreciated.

  Thanks

  Pablo

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  January 4, 2013 at 9:32 am

  #1573823

  Setup the job step type as an Operating system (CmdExec) and use something like ForFiles to delete the files...i.e.

  Forfiles -p "c:\Temp" -s -m *.txt -d -1 -c "Cmd /C del @FILE

  Tommy

  Follow @sqlscribe