SQL Server Performance Forum – Threads Archive

Deadlock Graph

Hello I have an alert which gets triggered on a Deadlock. This triggers a job which has the below code INSERT INTO DeadlockEvents(AlertTime, DeadlockGraph)
VALUES (getdate(), N’$(ESCAPE_SQUOTE(WMI(TextData)))’) I am trying to capture deadlock graph related data. the job gets triggered on an alert and the agent is trying to run the above code but the job fails with below error. Error: Unable to start execution of step1. (reason: Variable WMI (Text Data)not found). The step failed. I did not find anything related to this on the internet. Can some one help me as how to fix this error. Thanks

SQL Server Agent jobs fail when the jobs contain job steps that use tokens after you install SQL Server 2005 Service Pack 1
http://support.microsoft.com/kb/915845/en-us
Mohammed U.

Mohammed, thanks for your reply, but I do not think that this has to do with the Escape macro of a token. If you observer in my code I am already using the escape macro. Let me know if there are any other thoughts….

Which version of Excel is being used? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Satya, I am not sure with your question. This has to do with SQL Server and Agent. I am not sure where Excel is connected to do this ?

But there is a problem with the Office tools prior to 2003 version, due to the dependancy of these tools it is required. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>