Can''t schedule a profiler?

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  September 8, 2005 at 2:59 pm

  #115158

  It sucks to no end that it wasn't an option to schedule a profiler to start from the GUI at specific time in SQL SERVER 2000.

  But in SQL 2005 I don't see this option either! Am I missing something?

  Thanks for the suggestions

   

• September 12, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Chrislis

  SSChasing Mays

  Points: 622

  More actions

  September 12, 2005 at 4:46 pm

  #589211

  Maybe they thought that only a service could run a scheduled job. I think you could use Windows Scheduler and run Profiler with some parameters.

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  September 14, 2005 at 12:24 pm

  #589854

  thanks Crislis,

  But I am not able to find parameters with which to specify to start the profiler.

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  September 15, 2005 at 1:26 am

  #590024

  not sure if it applies in your case but how about putting an "endtime" filter on your trace; unfortunately it won't allow you to filter on a finer detail (eg. profile on thursdays only) but it will get you data from 2005-09-15 00:00:00 to 2005-09-15 18:00:00 for example.

  HTH

  Billy