다음을 통해 공유

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

  • Anonymous
    March 01, 2014
    Can I schedule CHECKDB job in all server though Central Management server?

  • Anonymous
    April 01, 2014
    @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.