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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-09-09 : 08:05:07
|
| Hello ,What rights do we need in order to see all jobs configured and running under SQL 2000 Enterprise manager ? A few of my admin collegues cannot see the jobs in the Enterprise manager .They all are DBO's for the databases with sysadmin rights . The server is SQL 2000 server with SP 2 . Is it sufficient or we need to have more rights which are missing ? Admin001 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-09 : 08:07:32
|
| Think you can only see jobs which you own unless you are sa in which case you can see them all.May be another role which allows access to them all as well - don't have a 2000 system here to check.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dontipton
Starting Member
8 Posts |
Posted - 2002-09-09 : 16:19:50
|
| The only way I've been able to see all jobs is by being System Administrator in the SQL instance. |
|
|
|
|
|
|
Cannot see jobs in Enterprise manager