I find Powershell can do almost everything. I just try to generate PDF or excel from Reporting service via web service call from Powershell.
I use Sql agent to run powershell on production. How do you usually scheudle PowerShell script? What are pros and cons?