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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-04-14 : 08:08:38
|
| Maybe some advice on which Login to use in EM is needed.I've got EM (on my server) logging in using windows authentication. I create scheduled SQL jobs, they run fine.I launch EM on my client, sign in as a SQL user, and view the server. All is well, but I can't see the scheduled Jobs.Seems unnatural, but is probably what Microsoft wanted. What's the reasoning?Sam |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-04-14 : 08:20:21
|
| what is the security context of your SQL account? Is it sysadmin?Sean Roussy |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-14 : 08:21:12
|
The SQL login doesn't have enough permissions to view jobs. Adding that login to sysadmin would fix that.Yeah, what he said.  |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-04-14 : 08:43:22
|
| Ahhh! It's good to view jobs. |
|
|
|
|
|
|
EM View job question