September 7, 2005 at 3:31 pm
My company has recently locked down everyone's access in SQL Server. I do production support and need to be able to look at the Job Log under Management --> SQL Server Agent --> Jobs. Currently with the lock down changes I can no longer look at the Jobs Log. Is there an account in SQL Server or a way to give someone just access to the Jobs Log?
September 7, 2005 at 5:12 pm
Job owner or member of SA can view job. You can ask the SA to give you the ownership of the jobs.
Amit Lohia
September 7, 2005 at 7:18 pm
I know they won't make me a member of SA because that gives you too much system access. How do you make someone the owner of a job?
September 7, 2005 at 7:21 pm
EXEC sp_update_job @job_name = <Job Name>, @owner_login_name = <Your Name>
Amit Lohia
September 7, 2005 at 7:31 pm
What if the job runs under a different login name then mine? Can I still be the owner or does the login it runs under need to be the owner? Basically I just want to have the ability to view the job log and nothing more.
September 8, 2005 at 9:51 am
So by runnning EXEC sp_update_job @job_name that will make you the owner of the SCHEDULED JOB but not the packages in it?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply