Scheduled execution of SQL statements using task plans

1. Prepare the SQL statement to be executed, for example:

Use ttnew // use the ttnew Database
Go
Insert into users (name) values ("") // insert a record to users
Save the statement in the user. SQL file and put it in the drive D and directory.

2. Write a batch file, for example:

Create another notepad, write the statement osql-E-I d: \ User. SQL in it, and save it as 11.bat.

3. Use the system task plan to call batch files and execute SQL statements

In the systemProgram-> Accessories-> System Tools-> Task Plan
Add a new task scheduler, click Next, browse, find the 11. BAT file, select the execution time, and click Next. Keep clicking. Enter the password of the Local Machine and click Finish.