Using SQL Enterprise Manager and the SQL Executive service, you can create server tasks and schedule them for execution at specified times. The tasks can be command executions, Transact-SQL statements, or replication tasks. A task can be scheduled to occur at a single specified time, on a recurring schedule, or when initiated by an alert. A task can also be executed immediately.
SQL Server processes also automatically create and schedule tasks. The System Administrator (SA) can use SQL Enterprise Manager to modify, disable, delete, and immediately run both user-created tasks and SQL Server-created tasks. (Users other than the SA can manage only tasks that they own.)
For more information, choose one of the following topics:
Viewing the Task List and Running Tasks
Setting the Task Engine Options