Allen White, who introduced me to the wonders of PowerShell at last year’s PASS Summit, has published a white paper on using PowerShell within SQL Server 2008 with Microsoft. This is great news. If you’re, as Brent Ozar so nicely put it, a noob like me in working with Powershell, this is going to be a great resource.
Congratulations Allen, and thanks.
I used that as a term of endearment, by the way. 😉
I teese. I am a noob, especially around PowerShell.
Excellent write up. Do you know of an easy way to script out all the jobs using powershell into a file?
Steve
From SQL Agent? I haven’t done it, no, but it shouldn’t be too difficult to walk the Jobs collection and output to a string or a table with calls to SMO.