All I need now is to not allow updates to existing jobs
Any ideas?
USE msdb;
CREATE ROLE JobsViewer AUTHORIZATION db_securityadmin;
GO
use msdb
EXECUTE sp_addrolemember 'JobsViewer', 'johntest1'
DENY EXECUTE ON OBJECT::msdb.dbo.sp_add_job TO JobsViewer
DENY EXECUTE ON...