getting DTS Packages logs and Status Using T-sql in seconds

By Chaitanya Talasila on January 10, 2012

Hi All,

For support people:

We can find the legacy DTS Packages logs and Status information using the below scriot

select

pklog.name as PackageName ,

stlog.stepname as StepName ,

stlog.stepexecutionid as StepExecutionID ,

stlog.starttime as StepStartTime ,

stlog.endtime as StepEndTime ,

stlog.errorcode as StepErrorCode ,

stlog.errordescription as StepErrorDescription

from

msdb.dbo.sysdtssteplog stlog

left join

msdb.dbo.sysdtspackagelog pklog

on stlog.lineagefull = pklog.lineagefull

where

stlog.errorcode <> 0

and stlog.starttime > DATEADD (day, -15, getdate())

order by

stlog.starttime

thanks for viewing

Regards,

Chaitanya

Send an Email : mssqlbuzz

Posted in: Uncategorized

SQL BLOGGING