Hi All,
I am a production DBA and have a produciton & test environment configured. There are several programmers who have Sys Admin access to the Test environment, this is where they do their work. Production is pretty much locked down.
One of the programmers wishes to be able to view the production jobs as well as the package logs of the DTS Packages via Enterprise Manager.
Is there a way to do this without giving him Sys Admin access?
Thanks in advance,
Chris.