Powershell White Paper
June 14, 2009 at 7:14 am (PowerShell, SQLServerPedia Syndication) (noob, PowerShell)
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.
brento said,
June 14, 2009 at 7:39 pm
I used that as a term of endearment, by the way. ;-)
scarydba said,
June 14, 2009 at 9:44 pm
I teese. I am a noob, especially around PowerShell.
Steve said,
June 22, 2009 at 1:26 pm
Excellent write up. Do you know of an easy way to script out all the jobs using powershell into a file?
Steve
scarydba said,
June 22, 2009 at 1:42 pm
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.