Also if it's successfully running in BIDS but not in Jobs, you might want to check that the SQL Agent user has access rights to the folder you are deleting from.