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 |
|
dwalker79
Yak Posting Veteran
54 Posts |
 Posted - 2008-07-16 : 18:48:32
|
| Can somebody please tell me which SQL 2000 server roles allow a user to create and schedule jobs? Is it only the SYSADMIN role, or are there other roles as well?Thanks!Dustin |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 19:44:43
|
| In SQL 2000, You need to have Sysadmin role to create and modify jobs? For only viewing job you can use Targetserverrole in MSDB system database. |
 |
|
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-07-16 : 19:55:37
|
| Thank you so much! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 22:31:35
|
| No, you don't need sysadmin rights to create job. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 22:45:16
|
| Can you show us how please? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:17:35
|
| You can try it on your server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 23:18:40
|
| How? Can you show? Maybe i dunno. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:30:51
|
| You kidding? Creata a non-sysadmin login and schedule a dts package to run as sql job. |
|
|
|
|
|
|
Create and Execute Jobs