Re: SQL Profiler Scheduling

Ron (Ron@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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.

What I do is simply to add a filter on StartTime to the trace, so the
filter is running all the time, but does not start capturing anything
until the time I've stated.

It's possible to set a stop time when you set up a trace.

The simplest way to set up a server-side trace is to define the trace in
Profiler, and then script the trace. If you are on SQL 2005, you need to
be careful to check that the filter conditions were scripted correctly.
This is not always the case.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: sp_trace_setfilter does not work
    ... I want to only see the activity from my application's login which is why I'm using the login filter. ... Also when I look at the trace file's properties using the profiler gui, there's nothing in the filter section. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Audit stored procedures
    ... Rather than using Profiler, use a server-side trace instead. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: sql profiler trace
    ... includes rows where is no value for a filter column in the trace. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler
    ... My question is, when setting up the filter, how do you use Lke & Not Like? ... Does Like exclude all not like? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: sp_trace_setfilter does not work
    ... However the trace is created but the filter ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)