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. 


Comments (2)

  1. Ramana says:

    Can I schedule CHECKDB job in all server though Central Management server?

  2. isilefe says:

    @Ramana, we have a solution called multi server administration for SQL Server agent, you can review master  server and target server configuration. This can be useful for you.