?
Solved

Run sql profiler as jobs on specific time frame

Posted on 2007-10-05
1
Medium Priority
?
280 Views
Last Modified: 2010-03-19
Hi,
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
0
Comment
Question by:motioneye
1 Comment
 
LVL 27

Accepted Solution

by:
ptjcb earned 2000 total points
ID: 20024609
Yes, you can do that. You would need to write a script using the sp_trace procedures.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Another choice is to create a trace definition and use that for the job

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1248035,00.html
http://www.sqlmag.com/Article/ArticleID/43014/sql_server_43014.html 
(may require registration)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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