Jonathan, though you wrote this 3 years ago, thank you VERY much for a clear, well-written, practical article that fixed a very thorny problem for me: allow users to execute a stored procedure to kick off a particular Agent job. You have no idea how much time and aggravation your article saved me.
If only I'd looked here before wading through all my other Google results.... :ermm:
Rich