• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1418
  • Last Modified:

Error trying to run sql jobs

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
  • 2
2 Solutions
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?
dcsearleAuthor Commented:
2Gb has been allocated and its using 1.26Gb.

It's running citrix & IIS services, unfortunately these can't be stopped.
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.
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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