Home Forums SQL Server 2012 SQL 2012 - General Logging for sql agent job in ssis 2012 RE: Logging for sql agent job in ssis 2012

  • June 25, 2014 at 10:12 am

    #1724709

    Koen Verbeeck (6/25/2014)

    peacesells (6/24/2014)

    I know in previous versions, msdb database would log/capture all sql server agent job details. Now with 2012 and SSISDB, if a job fails in SQL Agent where would it be logged? Also what queries are run behind the scence for execution reports we get in integration Service Catalogs?

    The actions are logged in the SSISDB database, if you are using the project deployment model.

    You can use SQL Server Profiler to find the executed report queries.

    Thanks- Does that mean that all SQL agent job activities are logged in the ssisdb database instead of traditional msdb for project deployment model? I see no information in tables in ssidb that that ties to SQL agent job?