• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▼Platform SDK
      • ▶Getting Started
      • ▶Design Strategies and Standards
      • ▶Base Services
      • ▶Component Services
      • ▼Data Access Services
        • ▶Microsoft Data Access Components (MDAC) SDK
        • ▶Jet and Replication Objects
        • ▶Microsoft XML SDK
        • ▼Microsoft SQL Server Programmer's Toolkit
          • ▶Getting Started
          • ▶What's New
          • ▶Installing SQL Server
          • ▶SQL Server Architecture
          • ▶Administering SQL Server
          • ▶Creating and Maintaining Databases
          • ▶Accessing and Changing Data
          • ▶Optimizing Database Performance
          • ▶Replication
          • ▶Data Transformation Services
          • ▶OLAP Services
          • ▶English Query
          • ▶Repository
          • ▶Building SQL Server Applications
          • ▶Troubleshooting
          • ▼How To
            • ▶Installing SQL Server
            • ▼SQL Server Enterprise Manager
              • ▼Administering SQL Server
                • ▶Starting, Pausing and Stopping SQL Server
                • ▶Backing Up and Restoring Databases
                • ▶Managing Servers
                • ▶Managing Clients
                • ▼Automating Administrative Tasks
                  • How to set the service startup account for SQL Server Agent (Enterprise Manager)
                  • How to set the mail profile for SQL Server Agent (Enterprise Manager)
                  • How to set the SQL Server connection (Enterprise Manager)
                  • How to set a SQL Server alias (Enterprise Manager)
                  • How to create a job (Enterprise Manager)
                  • How to disable a job (Enterprise Manager)
                  • How to create a job category (Enterprise Manager)
                  • How to delete a job category (Enterprise Manager)
                  • How to assign a job to a job category (Enterprise Manager)
                  • How to change the membership of a job category (Enterprise Manager)
                  • How to give others ownership of a job (Enterprise Manager)
                  • How to create a CmdExec job step (Enterprise Manager)
                  • How to reset SQLAgentCmdExec permissions (Enterprise Manager)
                  • How to reset the SQLAgentCmdExec account password
                  • How to create a Transact-SQL job step (Enterprise Manager)
                  • How to define Transact-SQL job step options (Enterprise Manager)
                  • How to create an Active Script job step (Enterprise Manager)
                  • How to set job step success or failure flow (Enterprise Manager)
                  • How to set up the job history log (Enterprise Manager)
                  • How to view the job history (Enterprise Manager)
                  • How to make a master server (Enterprise Manager)
                  • How to make a target server (Enterprise Manager)
                  • How to enlist a target server from a master server (Enterprise Manager)
                  • How to defect a target server from a master server (Enterprise Manager)
                  • How to defect multiple target servers from a master server (Enterprise Manager)
                  • How to view a master SQL Server Agent error log (Enterprise Manager)
                  • How to check the status of a target server (Enterprise Manager)
                  • How to schedule a job (Enterprise Manager)
                  • How to set CPU idle time and duration (Enterprise Manager)
                  • How to notify an operator of job status (Enterprise Manager)
                  • How to write the job status to the Windows NT application log (Enterprise Manager)
                  • How to automatically delete a job (Enterprise Manager)
                  • How to set the polling interval for target servers (Enterprise Manager)
                  • How to start a job (Enterprise Manager)
                  • How to stop a job (Enterprise Manager)
                  • How to force a target server to poll the master server (Enterprise Manager)
                  • How to view a job (Enterprise Manager)
                  • How to resize the job history log (Enterprise Manager)
                  • How to clear the job history log (Enterprise Manager)
                  • How to modify a job (Enterprise Manager)
                  • How to modify the target servers for a job (Enterprise Manager)
                  • How to modify a target server's location (Enterprise Manager)
                  • How to delete a job (Enterprise Manager)
                  • How to synchronize target server clocks (Enterprise Manager)
                  • How to script jobs using Transact-SQL (Enterprise Manager)
                  • How to create an operator (Enterprise Manager)
                  • How to assign alerts to an operator (Enterprise Manager)
                  • How to format pager addresses (Enterprise Manager)
                  • How to designate a fail-safe operator (Enterprise Manager)
                  • How to create an alert using an error number (Enterprise Manager)
                  • How to create an alert using severity level (Enterprise Manager)
                  • How to define the response to an alert (Enterprise Manager)
                  • How to create a user-defined event error message (Enterprise Manager)
                  • How to edit a user-defined event error message (Enterprise Manager)
                  • How to delete a user-defined event error message (Enterprise Manager)
                  • How to disable or reactivate an alert (Enterprise Manager)
                  • How to designate an events forwarding server (Enterprise Manager)
                  • How to view information about an operator (Enterprise Manager)
                  • How to edit an operator (Enterprise Manager)
                  • How to change an operator's availability (Enterprise Manager)
                  • How to delete an operator (Enterprise Manager)
                  • How to view information about an alert (Enterprise Manager)
                  • How to edit an alert (Enterprise Manager)
                  • How to delete an alert (Enterprise Manager)
                  • How to script operators using Transact-SQL (Enterprise Manager)
                  • How to script alerts using Transact-SQL (Enterprise Manager)
                  • How to set job execution shutdown (Enterprise Manager)
                  • How to autostart SQL Server Agent Monitor (Enterprise Manager)
                  • How to send SQL Server Agent error messages (Enterprise Manager)
                  • How to view SQL Server Agent error log (Enterprise Manager)
                  • How to rename a SQL Server Agent error log (Enterprise Manager)
                  • How to write execution trace messages to the SQL Server Agent error log (Enterprise Manager)
                  • How to schedule a DTS package using the SQLServerAgent service
                • ▶Managing Security
                • ▶Monitoring Server Performance and Activity
                • ▶Integrating SQL Server with Other Tools
              • ▶Creating and Maintaining Databases
              • ▶Accessing and Changing Data
              • ▶Optimizing Database Performance
              • ▶Replication
              • ▶Data Transformation Services
            • ▶Transact-SQL
            • ▶OLE DB
            • ▶ODBC
          • ▶Glossary
      • ▶Graphics and Multimedia Services
      • ▶Management Services
      • ▶Messaging and Collaboration Services
      • ▶Networking and Directory Services
      • ▶Security
      • ▶Tools and Languages
      • ▶User Interface Services
      • ▶Web Services
      • ▶Win32 API
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▶Knowledge Base
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples