Automated Administration How-to Topics (Transact-SQL)
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 Management Studio, but they can also be defined using Transact-SQL statements. The topics in this section describe how to use stored procedures to implement automatic administration of SQL Server.