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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy