• 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
error.bmp
0
dcsearle
Asked:
dcsearle
  • 2
2 Solutions
 
St3veMaxCommented:
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
 
dcsearleAuthor Commented:
2Gb has been allocated and its using 1.26Gb.

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