How to get a list of scheduled jobs (time and date it runs) across multiple servers?

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  September 21, 2011 at 3:32 pm

  #244208

  Hi there, i've been given a huge list of servers to check if any of them have DBs with jobs that occur on a Saturday between 5pm - midnight. Is there any way to check this via powershell?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 22, 2011 at 3:18 am

  #1385000

  This could be a starting point:

  http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell

  Hope this helps

  Gianluca

  -- Gianluca Sartori

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  September 22, 2011 at 9:01 am

  #1385226

  Thanks for the start in the right direction!