随笔分类 - SQL Server jobs

摘要：问： I have three stored procedures Sp1, Sp2 and Sp3.The first one (Sp1) will execute the second one (Sp2) and save returned data into #tempTB1 and the 阅读全文

posted @ 2019-12-04 14:48 PowerCoder 阅读(1775) 评论(0) 推荐(0)

如何查询正在运行的SQL Server agent job

摘要：运行"msdb"系统数据库下的存储过程"dbo.sp_help_job"，可以得知现在SQL Server中有多少个正在运行的agent job：查询结果如下：阅读全文

posted @ 2019-12-04 11:33 PowerCoder 阅读(1600) 评论(0) 推荐(0)