Does anyone have experience granting EXECUTE permission directly on this system stored procedure? I know Books Online says to use one of the fixed database roles in msdb but the highest of those (operator) is very broad and a big security hole. I'm just not excited about granting permissions directly on a system stored procedure.
Further, did it work like you expected? Did you find any other permissions issues? Did internal audit have any concerns?