SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Creating Windows Command Jobs

In this final job example, you will learn how to create a job that calls on a Windows command. The purpose of this job will be to send a server status report to the DBA from the SQL Server. You will first create a batch file in Exercise 13.4. The batch file will execute several commands in order to gather information about the state of the server.

EXERCISE 13.4 Creating a Batch File for Information Gathering

In this exercise, you will create a batch file that can be launched from a job in Exercise 13.5. This batch file will run command-line commands to store the server name, IP configuration, network statistics, and more information in a log file named C:\Logs\%date%-sysinfo.log. In order for the batch file to work ...