Koen Verbeeck (6/25/2014)

---

peacesells (6/25/2014)

---

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?

No, just the related SSIS information is logged in the SSISDB. The logging of the job and jobsteps is still in MSDB.