Results 1 to 3 of 3

Thread: Maintain Jobs, View Logs

  1. 03-13-2006, 02:25 AM #1
    JamesNewZealand
    JamesNewZealand is offline Registered User
    Join Date
    Feb 2006
    Posts
    7

    Maintain Jobs, View Logs

    I have a user who needs to check whether 2 jobs have run on a SQL Server 2000 instance, and be able to view logs.

    Is there a way of doing this, and not allowing them access to anything else?
    Reply With Quote Reply With Quote
  2. 03-13-2006, 08:49 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can create a view on sysjobhistory table in MSDB database and grant select access to the user.

    or If you have not disabled public privilege to add job to sql server, you can schedule the job using the user's login and the user can see it in Enterprise Manager.
    Reply With Quote Reply With Quote
  3. 03-13-2006, 10:40 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Or just change job owner to that user.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules