SQL Profiler has a template for long running queries. You could run profiler and have it log to a table on the server. Then have a SQL Agent that emails you rows whenever there are some. Not exactly neat, or easy, but a way. It stops of course as soon as Profiler is stopped.