February 3, 2016 at 8:23 am
SQL 2012 Enterprise...
Has anyone prepped a script which would list ALL SSIS Packages that have failed since a specified date?
If SSIS_Package_ABC failed Mon, Wed & Fri but succeeded Tues and Thurs, the report should list the package name for dates Mon Wed and Fri...
thanks for any suggestions...
(this link shows failed jobs but no dates: https://basitaalishan.com/2012/08/15/find-failed-sql-agent-jobs-using-transact-sql-script/ )
February 5, 2016 at 4:50 am
http://www.sqlservercentral.com/Forums/Topic1089382-147-1.aspx
Sagar Sonawane
** Every DBA has his day!!:cool:
February 6, 2016 at 5:20 am
thx Sagar -- the query in the link you provided (for SQL 2012) is good if you house pkg's in msdb...
We're housing our SQL 2012 Enterprise SSIS pkg's in the Integration Services Catalog / SSISDB (in 4 predefined User folders)
Our management would like to see every execution of every package over the last month... and it's status (success, failed)
Was hoping someone might have a canned script to render this info..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply