Automated Administration How-to Topics (Transact-SQL)
SQL Server 2005
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.
-
How to: Create a SQL Server Agent Job (Transact-SQL)
-
How to: Create a SQL Server Agent Master Job (Transact-SQL)
-
How to: Modify a SQL Server Agent master Job (Transact-SQL)
-
How to: Create Operators (Transact-SQL)
-
How to: Modify Operators (Transact-SQL)
-
How to: Create a SQL Server Agent Proxy (Transact-SQL)
-
How to: Modify a SQL Server Agent Proxy (Transact-SQL)
-
How to: Delete a SQL Server Agent Proxy (Transact-SQL)
-
How to: Delete a Job Step Log (Transact-SQL)
-
How to: View Job Activity (Transact-SQL)
