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?