I have a new developer that has inherited quite a few DTS packages that do everything from executing .exe files to calling stored procedures, ftping files , etc..
On our Production SQL Server, he has read-only to the User Databases only. Problem is, he cannot see the JOBS under the SQL Server Agent. I would like to give him access to be able to view jobs and job history. I've tried all kinds of combinations of permissions and cannot figure this out.. can anyone help me out?