ssislog

Please login or create account to add a snippet.

Follow @TagMyCode

Language: Text

Posted by: user2d6c2

Added: Jun 30, 2017 8:20 PM

Tags: no tags

USE RAHERODW
GO
SELECT TOP 200 spl.PackageName, tl.*
FROM SSISDB.dbo.SSISTaskLog tl
INNER JOIN ssisdb.dbo.SSISPackageLog AS spl ON spl.PackageLogId = tl.PackageLogId
ORDER BY tl.StartTime DESC
GO
SELECT * FROM SSISDB.dbo.SSISPackageLog WHERE SSISPackageLog.PackageLogId = 241
GO
SELECT * FROM raherodw.dbo.ETLJobStatusHistory ORDER BY ETLJobStatusHistory.LastSuccessfulRun desc