Shane O’Neill shows us Powershell’s switch statement:
We send out notification emails if jobs fail as well but hey, we’re DBAs, we like a backup!
Since this used to be done manually, and since I like PowerShell, I created separate functions that can take individual log files and parse out the needed data in a nice, easy format.
My problem, and the reason for this post, was figuring out, based on the name of the file in a directory, which function to call…
Click through to see how to use the switch statement, as well as how to switch on an expression.