job--error logs on multiple instances

• kritika

  Old Hand

  Points: 319

  More actions

  July 18, 2011 at 3:26 am

  #254578

  How do i get all the errorlogs of jobs from all instances on a server.or may be 2 servers.

  each server having 6 instances each.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  July 20, 2011 at 9:33 am

  #1355753

  you may want to use SQLOVERVIEW and then create some reports from the data collected.

  http://www.sqlmag.com/article/task-scheduling/sql-server-integration-services

  check also this link http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61621/ Good luck!

  ---

  
  
  My blog