Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services - 3
Time is automating data collection now. It is nothing but just a SQL Server agent job. After going through the usual steps while defining a SQL Agent job, the important thing is choosing “PowerShell” as type on “New Job Step” dialog.
And as a command you should type the same command as you configured before according to the instructions in my 2nd blog post in these series.
As a result you should have a dialog similar to the one below:
And as a last step, please don’t forget to define a schedule. I just configured it to run once a day except working hours.
Lastly, don’t forget to test your job not to hit any syntax or permission issue.