Seamie_
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER