schedule a trace
-
How do I go about scheduling a trace? and would some share the exact steps?
thanks
-
I hope this helps:
open profiler( Start>>Run>>Profiler)
File>>New>>Trace Template
Add all the Events, Data Columns and Filters you want to capture.
Save the Trace Template.
Test the template by doing Start>>Run>>Profiler.exe C:\PathToTemplate\YourTrace.tdf
if it seems to work eas expected, then create a schedule task on the machine that calls that same command:Profiler.exe C:\PathToTemplate\YourTrace.tdf
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
.... create a schedule task ....
I'd prefer to use a sqlagent job, because it captures jobinformation.
Maybe you cannot do this because your system's cmdshell is disabled.
In that case you can export the "start trace" statements from your profiler-trace.
Profiler File \ Save as \ export \ script trace definition\ ...
This generates a sql-script that you can run form a query-window or from within a sqlagent job.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply