Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
debug
Starting Member
29 Posts |
 Posted - 2003-08-08 : 06:38:12
|
Hi Folks,I am kinda stuck ....as I have no idea how to schdule atrace in a profiler which runs every 10 minutes.Please help.Regards,DU DU |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-08 : 07:14:26
|
| Which do you want, a trace or to run profiler? They are different, you know.To schedule a trace write a proc to call sp_trace_create (and the other sp_trace* procs). Then create a SQL Agent Job to run your newly created proc at your desired interval.Jay White{0} |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-08-08 : 12:22:27
|
| In addition, the easiest way to generate the script for the server side trace is to use Profiler to set up the required events,columns and filters etc and then choose File>Script Trace , this will generate the stored procedure calls for you. You can then schedule stop and start using a job calling sp_trace_setstatus. See BOL for syntax.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
|
|
how to schedule SQL profiler