OK, sorry, was busy with other work.

First, if you're doing this for users, you're going to find yourself in a bind at some point. Users leave companies, and new users come.

So, set up a role first, and a group in Exchange/email, for notifications.

I'd say you are on the right track for this with your code below. Build a procs that can do these things:

- start job

- query job

- stop job

Grant rights to a role to execute your procs and add the user to a role. You can add notifications to a job step or to the job (I think, don't have a 2005 instance handy) that send a note to a group in your email system (or an alias). Map that to your user.