This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.
Objectives:
Automate administrative tasks
Configure SQL Server Agent
Define jobs and create multiserver jobs
Define operators and alerts
Set up SQLAgentMail for job notification and alerts
Set up linked servers
Set up security for linked databases
Topics:
Configuring the SQL Server Agent
Implementing Jobs
Multiserver Jobs
Managing Server Events
Linked Servers
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
