Can a profiler trace be scheduled?

I need to run a Sql Profiler Trace on one of our sql server 2000 instances at 3:00 AM but rather than getting up at 3, I would rather schedule a trace to run. Can this be done? If so, where can I see an example?

Thanks

Yes.. you can do that... You can write your own script using sql tracing SP and functions.

Read :http://msdn2.microsoft.com/en-us/library/ms191006.aspx

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

The other way is ... you make a trace using the Profiler Tool and then you can script it. Once you create the script run the script using job...

Madhu