O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required