restricting scheduleding jobs

  • Is there any way I can restrict users from scheduling jobs on MS SQL Server 2000?

  • Are the users sysadmins? If so then no, if not then probably.

    CEWII

  • That is my problem, my users are not sysadmins, but still, they can schedule jobs.

  • I just did a bit of research and the answer is, you can't directly in 2000.

    But you could schedule a job yourself that periodically looks at sysjobs in msdb and disables or deletes any "unknown" jobs.

    CEWII

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

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