Once the Task Scheduler window appears, right-click Task Scheduler Library and select New Folder. Once logged in, launch the Task Scheduler. The first step is to log into the server containing the directory from which you want to automate file deletion. The steps outlined below will walk you through the steps of creating a new scheduled task which will call the ForFiles command to handle automatically deleting the older files. Though each file is only around 11MB, over time this can begin to add up and deleting these files eventually becomes a necessity. As a result, a new file is added to the directory every day.
The job runs daily and runs a continual trace logging any transactions that take longer than 3 seconds. To provide a little background on this, the example I will be working with pertains to an automated SQL runtrace Agent Job that I have running on the server. In the example outlined below, I will be creating a scheduled task to run daily which will delete files from a specified directory that are older than 90 days. One of the most useful tasks that can be automated, at least from my perspective as a Database Administrator, is the ability to perform automated file deletion. Though it does have some limitations when compared to the aforementioned options, there are still numerous actions that can be automated using the Task Scheduler. It provides a simple graphical interface and is much easier to navigate than command prompt or Powershell. The Windows Task Scheduler is a useful tool for automating various tasks within the Windows operating system.
0 kommentar(er)
