Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
folettra
Starting Member
15 Posts |
 Posted - 2009-12-09 : 09:34:16
|
| I am using SQL 2000 and have several users who I want to give access to the SQL scheduler. I want them to be able to stop and start jobs, view history and so forth. I do not however want to make them admins in order to give then this access?is there a way give them access to the SQL jobs with out putting them in the system administration role? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-09 : 11:10:43
|
| how will they interact with the SQL Scheduler or Have you built them another front end to do this? if you had another front end you can use adodb and fire up the jobs using a stored procedure. that is how I do it.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
folettra
Starting Member
15 Posts |
Posted - 2009-12-09 : 11:16:53
|
| They all use enterprise manager to create DTS packages and then I schedule them. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-11 : 13:47:45
|
something like this maybeCREATE PROCEDURE dbo.StartAgentJob @SQLJobName VARCHAR(100) , @StartStopSQLJob int (1 for start 0 for stop or whatever datatype you want here) WITH EXECUTE AS 'DOMAINNAME\someuser'AS BEGIN EXEC msdb.dbo.sp_start_job @SQLJobName; <><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Access to SQL Agent without Admin rights