June 1, 2006 at 12:36 pm
I have scheduled a simple job on the server of my company db server. And I'd like to try to see/view my scheduled job status and history (fail, success, or complete) on the same server by issuing the following script commands: (in SQL Query Analyzer)
select * from msdb..sysjobhistory
select * from msdb..sysjobschedules
But I get the permission errors: (in SQL Query Analyzer)
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobhistory', database 'msdb', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobschedules', database 'msdb', owner
'dbo'.
My Question:
----------------
Do you have any idea or another way for me to use if I do NOT have the
permission over the MSDB database, I still be able see the history and status for scheduled test job?
BTW, On the current MSDB db on my company db server, only 2 users have access priviledges are "sa" and "guest", but I do not have account or pwd to login as "sa" and "guest" users.
Thank you so much in advance.
June 1, 2006 at 1:24 pm
I don't think you can do much except ask for your login to be given access to MSDB. I suppose you could ask for a stored proc or view to be created in a db for which you have access. The sp or view could (I think) return the data you need without your needing permissions to the underlying tables.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply