Post reply

Can''t schedule a profiler?

  • 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

  • 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.

  • 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.

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply