?
Solved

Error trying to run sql jobs

Posted on 2008-11-17
3
Medium Priority
?
1,411 Views
Last Modified: 2012-05-05
I'm using sql server 2000 sp4 and I get the attached error msg when I try to run a job . No changes have been made to the server to trigger this error and there's plenty of memory & storage available. I've seen this before and I know a reboot will fix the problem, however I'm unable to continue to do this on a regular basis.

Does any know how to resolve this issue without rebooting ?

I'm nearly out of points, hence I've only allocated 45 but this will be changed to 250 when i get more
error.bmp
0
Comment
Question by:dcsearle
  • 2
3 Comments
 
LVL 13

Assisted Solution

by:St3veMax
St3veMax earned 135 total points
ID: 22977393
How much memory is SQL actually being allocated? Have a look at the Memory section of Task Manager.

What else is running on this box? IIS?
0
 
LVL 1

Author Comment

by:dcsearle
ID: 22983062
2Gb has been allocated and its using 1.26Gb.

It's running citrix & IIS services, unfortunately these can't be stopped.
0
 
LVL 13

Accepted Solution

by:
St3veMax earned 135 total points
ID: 22983280
You may find you're having RAM Issues.

IIS and SQL are notorious RAM hoggers and are not reccomended to be running on the same box.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question