Many of the repetitive tasks performed when administering a Microsoft® SQL Server™ system can be automated.
Jobs and tasks can be defined to run at specific times or after specific events. These jobs are most often defined using SQL Server Enterprise Manager, but they can also be defined using Transact-SQL statements.