For clarification- the Performance Profiler doesn't work on a 'snap-shot basis' (versions 1-3 used to, however and the Memory profiler does) - but this is incidental to giving you exactly what you want, I think.
So- I think the first place to start is with our command-line version of the profiler:
You can automate the running of this of course, and you can easily set it to run a profiling session that you have previously saved, using the GUI.
More info here:
http://www.red-gate.com/supportcenter/c ... alkthrough
Please let me know if anything is not clear.
Do you want the same question answered for the Memory Profiler? (if so, please post in the other forum)