November 28, 2004 at 6:46 pm
i cant start that program.guess something wrong with MS SQL server.
2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID
2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2780
2004-11-26 09:40:15 - ? [101] SQL Server HERNGYIH version 8.00.760 (0 connection limit)
2004-11-26 09:40:15 - ? [102] SQL Server ODBC driver version 3.85.1117
2004-11-26 09:40:15 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2004-11-26 09:40:15 - ? [310] 1 processor(s) and 256 MB RAM detected
2004-11-26 09:40:15 - ? [339] Local computer is HERNGYIH running Windows NT 5.1 (2600) Service Pack 2
2004-11-26 09:40:15 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2004-11-26 09:40:15 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2004-11-26 09:40:15 - + [260] Unable to start mail session (reason: No mail profile defined)
2004-11-26 09:40:15 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2004-11-26 09:59:35 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2004-11-26 09:59:38 - ? [098] SQLServerAgent terminated (normally)
Please help me.Wat does it mean an idle CPU?
November 30, 2004 at 3:32 pm
If you open Enterprise manager then open your sql server, then go to management, then right click on SQL Server Agent and select properties. On the properties page, click on the advanced tab. Toward the bottom is an idle CPU condition.
It sounds like there are some jobs set to execute when the CPU is idle, but there have not been any parameters setup in the above to define idle.
According to Books on Line
To set CPU idle time and duration
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply