包执行情况
来源:互联网 发布:淘宝助手打印电子面单 编辑:程序博客网 时间:2024/04/30 11:40
select b.source as package,a.source as task,a.starttime,a.endtime,right(convert(varchar(19),a.endtime - a.starttime,120),8) duration
from
(select source,executionid,sourceid,MIN(ID) id,min(event) event,min(starttime) starttime,max(endtime) endtime
from dbo.sysssislog
where starttime>='20130916'
group by source,sourceid,executionid ) a
left join
(select source,executionid
from dbo.sysssislog
where starttime>='20130916' and event ='Packagestart'
) b on a.executionid=b.executionid
order by package,starttime
--ETL执行时长
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
(select source,executionid,sourceid,MIN(ID) id,min(event) event,min(starttime) starttime,max(endtime) endtime
from dbo.sysssislog
where starttime>='20130916'
group by source,sourceid,executionid ) a
left join
(select source,executionid
from dbo.sysssislog
where starttime>='20130916' and event ='Packagestart'
) b on a.executionid=b.executionid
order by package,starttime
--ETL执行时长
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
0 0
- 包执行情况
- DTS执行情况
- 语句执行情况
- 更新的执行情况
- 追踪mysql执行情况
- 查询sql执行情况
- 查询组策略执行情况
- 2016锻炼身体执行情况记录
- SQL查询作业执行情况
- mssql查看语句执行情况
- JCONSOLE 监控SQL执行情况
- 采购订单执行情况表
- 查询计划功能执行情况
- tuxedo查看后台服务执行情况
- 关于计划的执行情况总结
- Sql Server 监控 Job 执行情况
- Java构造函数的执行情况
- Sql Server 监控 Job 执行情况
- 导入和静态导入
- android程序崩溃后重启
- 数据库设计三范式
- Android解析json数据的几种方法
- Android USB Host(Android USB 主机通讯)
- 包执行情况
- 塘沽装修公司哪家好
- 常见浏览器兼容性问题与解决方案
- 让tableview 滚动到顶部 一句话搞定
- Android多语言支持以及各国语言Values文件夹命名规则
- C#多线程问题
- 常用C/C++编译器和IDEs
- 冬季装修注意事项
- 【poj 2054】 Color a Tree