×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Text
Posted by: user2d6c2
Added: Jun 30, 2017 8:20 PM
Views: 2
Tags: no tags
  1. USE RAHERODW
  2. GO
  3. SELECT TOP 200 spl.PackageName, tl.*
  4. FROM  SSISDB.dbo.SSISTaskLog tl
  5. INNER JOIN ssisdb.dbo.SSISPackageLog AS spl ON spl.PackageLogId = tl.PackageLogId
  6. ORDER BY tl.StartTime DESC
  7. GO
  8. SELECT * FROM SSISDB.dbo.SSISPackageLog WHERE SSISPackageLog.PackageLogId = 241
  9. GO
  10. SELECT * FROM raherodw.dbo.ETLJobStatusHistory ORDER BY ETLJobStatusHistory.LastSuccessfulRun desc