Profiler trace

Last Post 23 Nov 2011 06:35 AM by darko_73. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
darko_73
New Member
New Member

--
23 Nov 2011 06:35 AM
Hi,
I am running two traces:
1.RPC Completed and SQL BatchCompleted
Columns:EventClass, TextData, ApplicationName, LoginName, Duration and StartTime
Filter: Duration > 4000

2.RPC Completed and SQL BatchCompleted
Columns:EventClass, TextData, ApplicationName, LoginName, HostName and StartTime
Filter: TextData like %delete% and %update%.

Both run fine if I start them manually. I am getting statements that run longer than 4 seconds and for 
the socond one I am getting only update and delete statements.
When I run them through sql agent as a job the second trace is returning me everything - all statments 
insckuding select. What can cause this problem?

Thanks




Acceptable Use Policy
---