Run sql profiler as jobs on specific time frame

Posted on 2007-10-05
Last Modified: 2010-03-19
I would like to know how can I create a sql profiler and run it as a jobs, I would like the trace to be started at 1am in the morning and end at 5am in the morning
any idea how could I do this
Question by:motioneye
    1 Comment
    LVL 27

    Accepted Solution

    Yes, you can do that. You would need to write a script using the sp_trace procedures.

    Another choice is to create a trace definition and use that for the job,295582,sid87_gci1248035,00.html
    (may require registration)

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now