select source,DATEDIFF(MINUTE,MIN(starttime),max(endtime)) as duration
from dbo.sysssislog l
inner join msdb.dbo.sysssispackages p
on l.source = p.name
inner join msdb.dbo.sysssispackagefolders f
on p.folderid = f.folderid
and f.foldername='SSISFolderName'
where starttime>='2013-11-15 00:00:00' --and starttime<'2013-11-11 09:00:00'
group by source
order by duration desc
from dbo.sysssislog l
inner join msdb.dbo.sysssispackages p
on l.source = p.name
inner join msdb.dbo.sysssispackagefolders f
on p.folderid = f.folderid
and f.foldername='SSISFolderName'
where starttime>='2013-11-15 00:00:00' --and starttime<'2013-11-11 09:00:00'
group by source
order by duration desc
5051
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
