SQLAgent - TSQLJobStep (Job 0xXXXXXXXXX : Step 3)
猜测这个0x开头的代码应该是个什么ID,但是查询msdb的sysjobs和sysjobsteps里面好像都找不到它。
请问有什么办法查到它对应哪个具体的job吗?谢谢。
-- 看看跑的是什么语句
dbcc inputbuffer(spid)
SELECT * FROM msdb.dbo.sysjobs
SELECT * FROM msdb.dbo.sysjobsteps
DECLARE @job varchar(100), @jobID varchar(100)
select @job = 'SQLAgent - TSQL JobStep (Job 0xB2525BC0DBA1E844B582EFB55131EACF : Step 1)'
set @job = replace(@job, '(Job 0x', '(0x')
set @jobID = replace(@job, 'SQLAgent - TSQL JobStep (', '')
if (select charindex(' ', @jobID, 1)) > 0
begin
set @jobID = substring(@jobID, 1, charindex(' ', @jobID, 1)-1)
end
select replace(@job, @jobID,
(
select distinct name
from msdb.dbo.sysjobs
where master.dbo.fn_varbintohexstr(job_id) = @jobID
)
)
DECLARE @job varchar(100), @jobID varchar(100)
select @job = 'SQLAgent - TSQL JobStep (Job 0xB2525BC0DBA1E844B582EFB55131EACF : Step 1)'
set @job = replace(@job, '(Job 0x', '(0x')
set @jobID = replace(@job, 'SQLAgent - TSQL JobStep (', '')
if (select charindex(' ', @jobID, 1)) > 0
begin
set @jobID = substring(@jobID, 1, charindex(' ', @jobID, 1)-1)
end
select replace(@job, @jobID,
(
select distinct name
from msdb.dbo.sysjobs
where master.dbo.fn_varbintohexstr(job_id) = @jobID
)
)
---------------------------------------------------------------------------------- -- Author : htl258(Tony) -- Date : 2010-07-06 23:13:19 -- Version: Microsoft SQL Server 2008 ...
EXEC xp_cmdshell --*执行DOS各种命令,结果以文...EXEC xp_loginconfig --*报告SQL Server 实例在Windows 上运行时的登录安全配置 EXEC xp_logininfo --*返回有关Windows 认证登录的信息。 EXEC xp_msver --*返回
wordfile.uew 文件设置方法 /L6"XML" XML_LANG Noquote Block Comment On = File Extensions = XML XUL XSD XSL XSLT WSDL LOG PCF CFG TRACE CONF SLN VCPROJ ENV /Colors = 0,8421376,8421376,8421504,255, ...
性能监视 ... SQL Server 2008监视本质上可以分为5个区域:系统资源;SQL Server自身;数据库;数据库应用程序和网络。 监视和优化SQL 的策略是相当简单的,分为以下几步:创建一个性能基准;
Sql Server Replication Scripting Setup 大概的一个拓扑, 我们将三种角色分别安装在三台不同的 sql server 服务器上 1.1 distributor 1.2 publisher, publication, article 1.3 subscriber , subscription ...
写这个存储过程的初衷就是当有业务部门反映系统慢时,能快速知道数据库是否有阻塞,blocking其他进程的SQL是什么。后来又有一个需求想实现:在停止数据库服务之前,能快速知道数据库当前运行着什么SQL,以决定是否...
SQL Server数据库文件恢复技术SQL Server数据库备份有两种方式,一种是使用BACKUP DATABASE将数据库文件备份出去,另外一种就是直接拷贝数据库文件mdf和日志文件ldf的方式。下面将主要讨论一下后者的备份与恢复。...
Transact-SQL 参考 系统存储过程在 Microsoft® SQL Server™ 中,许多管理和信息活动可以通过系统存储过程执行。系统存储过程按这些分类分组。 分类
Mar18: DataPump KEY WORDS:DATA PUMP ; EXPORT expdp ,4 modules by user/tablespace/tables/full; IMPORT impdp , 4 modules either; ...DIRECTORY create direacory ,grant ** on ...
由于自己正在做一个高性能大用户量的论坛程序,对高性能高并发服务器架构比较感兴趣,于是在网上收集了不少这方面的资料和大家分享。... 初创网站与开源软件 6 ? 谈谈大型高负载网站服务器的优化心得!...
由于自己正在做一个高性能大用户量的论坛程序,对高性能高并发服务器架构比较感兴趣,于是在网上收集了不少这方面的资料和大家分享。希望能和大家交流 ... ————————————————————————————...
_/_/_/_/_/ 444444444 ~~~~~~ _/ _/_/ _/ _/_/ _/_/ 4;;;;;;;;4 Internet Superheroes ~ _/
Servlet: 1)servlet : servlet是一个特殊的java... 2)Servlet;作用: 主要用于控制层.... 3)Servlet;...3.1实现接口servlet,复写所有的方法;...3.2在web.xml文件中配置servlet内容. >>在web.xml文件中的配置,目的是通知W
12 Essential Steps After Installing SQL ServerBy : Sadequl HussainJul 13, 2009 From: http://www.sql-server-performance.com/articles/dba/post_installation_steps_p1.aspx
/L1"C/C++" Line Comment = // Block Comment On = /* Block Comment Off = */ Escape Char = \ String Chars = "' File Extensions = C CPP CC CXX H
Patch information Title: ALM / QC 64-bit Patch 12 S-Chinese Document ID: KM00410706 Product: Quality Center ...V
Swingbench Dominic Giles Blog SBUtil inAction (And Some Fixes) 12/03/15 18:44 As a means of demonstrating what you can achieve with SBUtil I’ve createda little test to show it’s possible to ...
网上有一个汉化好的 压榨XP手册 是基于他的汉化版 现在我贴出的是英文原版你还可以向作者捐献15$以便获得一个自动优化XP的脚本原文:http://www.bold-fortune.com/forums/index.php?...
拉取到it-ebooks.info的所有电子书列表。方便查找
metasploit的框架目录,位置在 /usr/share/
Porting to DB2. Universal Database. Version 8.2 from Microsoft. SQL Server2000 By Amyris V. Rada IBM Toronto Lab arada@ca.ibm.com (Reprinted courtesy of developerWorks DB2, at ibm.com /developerworks/
Web Site Test Tools and Site Management Tools More than 500 tools listed in 13 categories Organization of Web Test Tools Listing - this tools listing has been loosely organized into ...
Interview questions on WinRunner How you used WinRunner in your project? - Yes, I have been using WinRunner for creating automated scripts for GUI, functional and regression testing of the
From: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382%28v=vs.85%29.aspx Applies to: desktop apps only ...The information on this page is intended to be used by programm
#### 感谢it-ebooks团队 #### it-ebooks电子书质量很好,但搜索功能不太完善 #### 格式说明: [年份] 书名 || 副标题 || 页码 || 链接 #### [2015]: Data Mining Algorithms || Explained Using R || 720 ||...
('rods', 100) ('carbohydrates', 100) ('stresses', 100) ('premiered', 100) ('cyrus', 100) ('drastically', 100) ('eukaryotic', 100) ('witchcraft', 100) ('accompaniment', 100) ('conventionally',
LONG PAPERS (MAIN CONFERENCE) SphereRE: Distinguishing Lexical Relations with Hyperspherical Relation EmbeddingsChengyu Wang, XIAOFENG HE and Aoying Zhou Learning from Dialogue after Deployment: Fee...
ØMQ - The Guide Table of Contents By Pieter Hintjens, CEO of iMatix Please use the issue tracker for all comments and errata(勘误表). This version covers the latest stable(稳定的) relea
RAC Frequently Asked QuestionsGrid Computing / RACGeneral RACIs it supported to install Oracle Clusterware and RAC as different users. Why does netca always creates the listener which listen
淘宝/天猫/京东/拼多多/苏宁易购/小米商城/华为商城/抖音直播/茅台抢购助手,功能非常多,很强大的一款秒杀抢购软件!