isabel-1114008
SSC Eights!
Points: 919
More actions
July 16, 2009 at 9:31 pm
#75503
Is there any way I can restrict users from scheduling jobs on MS SQL Server 2000?
Elliott Whitlow
SSC Guru
Points: 102402
July 16, 2009 at 9:36 pm
#1025984
Are the users sysadmins? If so then no, if not then probably.
CEWII
July 16, 2009 at 9:39 pm
#1025986
That is my problem, my users are not sysadmins, but still, they can schedule jobs.
July 16, 2009 at 10:41 pm
#1026002
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply