Error trying to run sql jobs

Posted on 2008-11-17
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
Question by:dcsearle
    LVL 13

    Assisted Solution

    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?
    LVL 1

    Author Comment

    2Gb has been allocated and its using 1.26Gb.

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

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now