You can use this feature to schedule any valid SQL command to run at a given time and frequency. For instance, you can use this feature to run DBCC commands, stored procedures, and so on. You can also enable status logging and review the status log file for SQL commands that have been run.
Note To run more than one SQL command per task, use a stored procedure.
Create a New SQL Command
Modify a SQL Command
Delete a SQL Command
Maintaining a Site Database Overview