• Thats a nice idea. My client uses something similar to trigger the distribution agent job for replication.

    I wonder though if this is a 2k5 server, why you would not just add these users logins to the SQLAgentOperatorRole, there by allowing them most SQL Agent priviledges they had before. I think there are a few things this role still can't do, but it would suffice for most things and they probably wouldn't even realise their priviledges had been taken away 😉

    Kindest Regards,

    Frank Bazan