Take care - C2 Auditing seemed to cause my server to crash.
C2 Auditing is handled through trace events. I prefer to use customized trace (store them to a file.)
You can automate it.
Profiler has UI, trace doesn't have one, other than that fucntionality wise you will capture the sme information.