Sweet Baby

select top 100 * from dbo.sysdtspackagelog order by starttime desc

select top 100 * from dbo.sysdtssteplog order by starttime desc

–get error

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 1=1

–and stlog.errorcode 0

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

order by stlog.starttime