Re: SQL Profiler Scheduling

Ron,

Sure, just use a SQL Agent job to start the trace running at 8am. The job
will just run a second or two, then the trace will be started.

Create a trace interactively then save the script and use the script in the
job step. Be sure to set a stop time in the trace definition. E.g.

-- Set a stop time for the trace
set @DateTime = SUBSTRING(CONVERT(char(10),GETDATE(),120),1,10) + '
17:00:00.000'

RLF

"Ron" <Ron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F827E8B5-274A-4894-9472-39BE7C2A57E3@xxxxxxxxxxxxxxxx
Using SQL2005 Standard Edition SP1

Is there anyway to schedule a profile trace? I would like it start at 8am
and stop at 5pm without manual intervention. It could overwrite itself or
not.

We have occasional slowness that we can't seem to capture, so having a
trace
start each morning would help us when the problem occurred.

Thanks

Ron


.

Relevant Pages
Loading