Suppose we have scheduled our packages through SQL Server Agent Job and we receive the notification that one of our packages has failed.
To get its details, within SSISDB, we can check the Standard Reports like Integration Services Dashboard report, All Executions etc. to get the details.
This will provide the information about the operation that have run or are currently executing.
We can click on Failed record link to filter the report.
Or we can Filter it through Filter Settings dialog box as shown below
Open up the report for which we want to check the messages and click on View Messages link to get the details.
We can also view these standard reports (All Execution and All Validations) for a specific project as well.
We can also make use of Active Operation Dialog Box to check the status of currently running SSIS packages and stop it if needed.
Hope it helps..
2 thoughts on “Monitoring SSIS package Job Status”