task scheduler delete files

This article is generated in the writing of personal site backup script when you see, stay for referenceProblem scenario: Because my company has too many servers, the daily backup log files that I've created accumulate over the long haul. And do not need to keep so much, according to company requirements only need to retain one weeks. 1. What is the way to automatically delete the *.log

CREATE EVENT ' E_del_tbl_base_count ' On SCHEDULE every 1 day starts ' 2013-06-23 17:33:43 ' On completion not PRESERVE ENABLE does call P_del_count (90); The above code indicates that the p_del_count stored procedure is executed once every day from 17:33:43 2013-07-30 and takes the parameter 3. Create a stored procedure:[SQL]View Plaincopy P_del_count DELIMITER $$ -- --Stored procedures -- CREATE PROCEDURE ' P_del_count ' (in' Date_inter ' INT) BEGI

A problem encountered earlier is that the log file is too large to occupy the disk space and cause the build project to fail So I wanted to write a timed task. Delete a log or compress a log file I've been on the internet for a long time and haven't found the right script. So I consulted others, wrote a, share to the not found and need such a script novice students Advantages: Timed compression, save space

0x0 return code indicates a successful execution).　　Note: (i) A Chinese garbled behavior may occur when creating a bat file that is called by a scheduled task because it is not ANSI-encoded when the bat file is created, and only ANSI-encoded to support Chinese. Methods to create a bat file that supports Chinese: 1, in the face of this situation is the encoding of different problems, so at the beginning of the code should be corrected, support for Chi

Stop at %date%-%time% >>delete_old_backup.log echo Delete the log backup start at%date%-%time% >>delete_old_b Ackup.log set Logbackuppath=m:\db_backup\log_backup forfiles-p%logbackuppath%-m*. trn-d-%daysago%-C "cmd/c del/q @FILE" >> delete_oLd_backup.log echo Delete The log backup Stop at%date%-%time% >>delete_old_backup.log Echo---------------- ----------------------------->>delete_old_backup.log After

Settings method reference blog : collect server daily reports with PowerShell, and send messages to Administrators, HTTP.// yuntcloud.blog.51cto.com/1173839/1605561] Control Panel-Administrative Tools-Task Scheduler-Create tasksThe configuration is as follows:General: Enter name, description-tick "Run regardless of user login"-Enter password-tick "run with maximum privileges"Trigger: New-Select "Schedule"

some files and obtain some space. When I log on to the server, I find that there are no files to be deleted, but the disk space on the server is full for more than five minutes, and the leaders are worried, in the end, there is no way to delete some files that have been backed up to the backup server on the server tha

. Method 6: You can use the WinRAR program to delete the file. Right-click the AVI file and select "add to compressed file" in the pop-up menu ", in the "General" tab in the pop-up window, select the "delete source file after compression" check box. After confirming the operation, perform the compression operation. Delete the compressed file. Method 7: Call the W

This is a stationery pattern in outlook. It can be used and deleted if it is not used. If you do not need outlook to send and receive emails, delete all emails. C: \ Program Files \ Internet Explorer \ signup There is a program shortcut to start the Network Setting wizard. If your network is normal and you do not need the help of the wizard, delete it. I

different times of the extended period, to this, how to deal with the program? Our idea is to delete a file that has been extended over the current time period, and then to perform the delete task after hibernation for a period of time, which is equivalent to periodically performing a delete task.The complete C progra

I believe many of my friends have encountered some "stubborn" files that cannot be deleted. They do not show that the file is being used, that is, the file is read-only. If a dual system is installed, you can restart another system to delete it, or use unlocker to delete it. Of course, you need to download and install it before using unlocker. However, if you do

Let me tell you the way I used to use it. First, restart the computer and then delete, Two, use 360 forcibly deletes, Third, make a delete file deletion: Method, you can build a text file To enter this code inside del/f/a/q?%1 RD/S/q?%1 Save it as a file for example Xx.bat format and drag the U file into the. bat format file to remove it. You can try, I'll use this method to

The script is placed in a timed task instead of a service to perform some operations more convenient, the following is the implementation of the Delete folder under the N-day file created by the VBS script, in the configuration file DelFolderList.txt to remove the file path, only-del-files under the path is to delete o

become blank without any icons, and then use the del or RD command in the Command Prompt window to delete files or folders. After the operation is successful, enter explorer in the command prompt and press the Enter key to execute the operation, and the desktop is restored to the original state. If you forget to open the Command Prompt window before shutting down the assumer.exe process, you can click the

you want to upgrade these files, the changes must be made before the Windows protection mode core starts. Therefore, Windows provides a mechanism based on the Wininit. ini file to complete this task. This mechanism is to write the command into Wininit. ini in a certain format for applications that want to delete or rewrite such files.When Windows restarts, it se

The SQL Server database has log files, log files that record user actions to modify the database. You can clear the database log by simply deleting the log file and emptying the log Friends who use the MS database will know a problem, C disk space is very easy to fill up. Because the system disk on the partition is relatively small, this is because the database during the use of the log

In the company project, due to do a QR code scanning platform project, is expected to produce a daily two-dimensional code image to more than 10 g, so to do a scheduled cleanup task to regularly clean up the picture, according to different scenes to keep the picture, the rule is: 1, two-dimensional code unified login image for several hours effective 2, Electronic Business card QR code days ago, These parameters are configurable.At first, directly wit

When copying a large number of files, it is inconvenient to use CP (for example, after the command is accidentally interrupted, it cannot be resumed; if it is forcibly overwritten, it will waste time; if it is not overwritten, echo "N" | CP-r/source/destination can be used to complete the task. However, after my experiment, the overwriting prompt passed to the CP will also delay time, so there is also a was

display driver library files, file subsystem library files, etc. If you want to upgrade or modify these files, it must be performed before the Windows protection mode core is started. Therefore, Windows provides. an INI file mechanism to complete this task. This mechanism is to de