Failed to retrieve data for the request - Jobs SQL Server 2008

Hello all,
I created a Job on SQL Server 2008 to run a stored procedure ever 45 minutes for 3 days. The database itself is kept on SQL Server 2005 but I use 2008 to connect to it.
Once the job was created I then went to review the job and clicked the 'explode' icon beside SQL Server Agent.

Then when I clicked the 'explode' icon beside 'Jobs' after a short wait I got the error in the image below. From querying the tables involved it doesn't seem like the job is running which isn't a major issue. It's the fact that if the Job was creating a problem I'd have no way of terminating it.

The people on SQL 2005 don't see the job listed in their client consoles. However in 2005, the jobs are listed under the database whereas on 2008 they're listed under the Server. Neither I nor the others have SysAdmin rights on the database in question though we do on others on the network.

Can anyone help me to:
1. Fix it so I can review the job(s)
2. Suggest how I might delete the job?
10-08-19-ScrnShot-Job-Error-EE.JPG
Seamie_Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

8080_DiverCommented:
The people on SQL 2005 don't see the job listed in their client consoles.
That would be because the job is actually on the SQL Server 2008 instance.
However in 2005, the jobs are listed under the database whereas on 2008 they're listed under the Server.
That really has no bearing on the issue . . . except that it can create a little bit of confusion in finding the job when you are looking for it.
Neither I nor the others have SysAdmin rights on the database in question though we do on others on the network.
This is the crux of the problem.  How did you get the job created on the SS2008 instance in the first place?  It may be that you didn't really get the job set up and/or enabled (which would be why it isn't running).  Since it isn't running on the 2008 instance, have you considered setting it up and running it on the 2005 instance?  (That may be aat least a short term solution.)  
Can anyone help me to:
1. Fix it so I can review the job(s)

You will need to get more advanced privileges.  (Unfortunately, I am a Development DBA and not an Admin DBA, so I always ask our Admin DBA to give me permissions to do [fill in the blank] and he does . . . but he doesn't tell me what they were. ;-) ]
2. Suggest how I might delete the job?  
You may need to ask the Admin DBA to delete it for you.
It's the fact that if the Job was creating a problem I'd have no way of terminating it.
That is an issue that would probably need to be addressed by a policy.  If the Admin DBA doesn't let you have permission to access the jobs and their history, then the Admin DBA has to accept responsibility for making sure that the jobs run and run correctly or that they get disabled and the appropriate developer notified so that the problem can be corrected.
Good luck.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Seamie_Author Commented:
Given the time limits on outstanding questions and with this being the silly-season (summer leave etc.) I can not test the suggestion currently. However, what has been written makes sense and follows along the same thoughts I had on the issue.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.