security for Jobs

  • Is there a way I can set up a user to have permissions to view jobs & job history but not have them as sysadmin? Also, what if I want them to be able to schedule jobs without being sysadmin?

  • from BOL: Anyone can create a job, but a job can be edited only by its owner or members of the sysadmin role.

    We use a separate ID to own and run all jobs in the system.

Viewing 2 posts - 1 through 1 (of 1 total)

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