Many of the examples covered in this chapter can be run ad hoc. However, to enable more continuous monitoring, you will need to schedule these scripts to run regularly. You can use a number of options for scheduling. You can take advantage of SQL Server Agent and you can create a job that uses either a PowerShell step or an Operating System (CmdExec) step. Alternatively, you can use Windows Task Scheduler or vendor-specific schedulers, if they are available to you.
PowerShell for SQL Server Essentials
By :
PowerShell for SQL Server Essentials
By:
Overview of this book
Table of Contents (15 chapters)
PowerShell for SQL Server Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Getting Started with PowerShell
Using PowerShell with SQL Server
Profiling and Configuring SQL Server
Basic SQL Server Administration
Querying SQL Server with PowerShell
Monitoring and Automating SQL Server
Implementing Reusability with Functions and Modules
Index
Customer Reviews