Post reply

Can non-sysadmins administer jobs?

  • August 12, 2003 at 7:23 am

    #83039

    Is there a way that I can let 2 users administer all jobs on their server without making them sysadmins? They are both dbo's of the user database and have to change and run cmdexec and transql jobs.

  • August 12, 2003 at 8:13 am

    #469580

    hi,

    try allocating the users to the TargetServersRole Database role in msdb

    this seems to work for us.

    Paul

  • August 13, 2003 at 1:04 pm

    #469807

    read about the changes for TargetServerRole in SQL2K SP3

  • August 13, 2003 at 3:29 pm

    #469815

    It's not very secure but you can enable non-sysadmins to execute jobs.

    Go to the SQL Server Agent properties window, Job System tab. You can uncheck the "Only users with SysAdmin..." box.

  • August 14, 2003 at 1:05 am

    #469860

    Thanks Paul. Adding the users to the TargetServersRole indeed solved my problem. (If I look at the permissions for this role, I don't know how!, but it works.) But then it seems that this will only work until we upgrade to SQL2000 + SP3 (thanks suskno@saif.com ) which will not happen for quite a while yet.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply