zedtec (4/1/2014)
If I was to use only one job will the trace still start and stop at specified times?If using two jobs would I add my trace script in both jobs or just the start time job?
Or could I add 2 schedules into the same job one for start and one for stopping?
What would work best for this?
Thanks.
(1) No, unless sp_trace_start (or whatever it's called) allows you to specify how long the trace will run before it stops
(2) No, the second one would just run sp_trace_stop (or whatever it's called)
(3) You can have more than one schedule for the same job, but that wouldn't work here, because you've got two separate tasks. Therefore, the only way to schedule them separately is to put them in separate jobs.
John