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.

Comments are closed.

Skip to main content