How to check verbose SQL Server Agent Logging

Sometimes, the sql agent history does not provide enough information for debugging purpose. There is a way to see verbose logging information for each step:
go to a specific job step and click edit and go to Advanced tab
you can see Log to table or output file.. Click View and you can see much detailed log information

url: http://www.mssqltips.com/sqlservertip/1411/verbose-sql-server-agent-logging/

How to resolve this error in SSIS .ispac has been used by another process

Sometimes in SSIS, you may encounter this error when try to execute a ssis package

 

The process cannot acces the file 'ssisproject.ispac' because it is being used by another process.

 

Solution:

End all dtsDebugHost.exe under Processes

Name might be different if OS is windows2012

Detailed explanation here:

http://microsoft-ssis.blogspot.ca/2013/12/the-process-cannot-acces-file.html