Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

Unable to view jobs in sql server 2000

My users were not able to see jobs all of a sudden, can u pls throw some light pls...we are using a sql server 2000 in this case.
Nothing has chnaged as of users view. from the last 2 days msgs were not available in Error log to know wat hapnd.
they were a part of serveradmin roles and shud be able to see them,
0
anilkullam
Asked:
anilkullam
  • 4
  • 2
1 Solution
 
reb73Commented:
Can you verify if they are still members of the serveradmin role?

Is there any chance the 'Builtin\Administrators' group was removed from the logins??
0
 
anilkullamAuthor Commented:
nopes ...they are still members of the server admin ....and they are able to login the server ...only prob is ...they are not able to see the jobs simple....:(
I guess removing the builtin\Admin group is not a possibility since they were able to login
0
 
reb73Commented:
What Service Pack patch level is the server at??  (Run select serverproperty('productlevel') to find this)

If its SP3 or higher, can you check if these users are listed under TargetServersRole database role in msdb database? If not, try adding them there to see if that helps..
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
mordiCommented:
Hi,
Just restart the server.
0
 
anilkullamAuthor Commented:
Thanks yaar, will chk with the suggested replies in another 1 hour.
0
 
anilkullamAuthor Commented:
U know wat..i have got this info by googlin' but not as clear as urs. KEWL thanks buddy
0
 
anilkullamAuthor Commented:
but i still have a prob...for one user A adding him to targetserverrole did work..but for the other B i have added his login to the security role and did the same under msdb but complain that he is not able to see the jobs...default db is master for the user B and since we have added him to msdb ..it also counts thats the info part...now i wanted to try is...delete user B from the security roles..taking him back to his previous state...can anybody suggest on this pls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now