April 4, 2006 at 10:48 pm
We have SQL Server 2000 with SP 4
Windows 2003 Server
Sql Agent stops automatically after sometime
& our application is depend on Job running on particular time
It is very urgent
Thanks in Advance
April 6, 2006 at 2:52 am
Had simalar problem when servers were upgrade from an NT Background to windows 2000 and some to 2003, The windows 2003 server is the domain controller. Was advised that when all the servers were in a windows 2003 domain with no pre compatiblity for early operating system, this problem would go. I have not personnal upgrade, due to costs.
April 6, 2006 at 3:10 am
Thanks for your reply
can anyone tell me how to start SQL Server Agent manaully i.e.
i want to write some BATCH file to start SQL Server Agent
April 6, 2006 at 8:45 am
Create a batch file called RestartAgent.BAT with the following commands in it, and save it on the C:\ drive:
@ECHO OFF
NET START SQLSERVERAGENT
While running the above command, make sure you are logged in as an administrator on the SQL Server computer. Also make sure, the 'Task Scheduler' service of Windows 2000 is running and it's startup type is set to Automatic.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
April 6, 2006 at 11:53 pm
Thanks for your response
Can u tell me why SQL Server Agent is shutting Down
This is what i got from LOG File
2006-04-06 03:15:04 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID
2006-04-06 03:15:04 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 5436
2006-04-06 03:15:04 - ? [101] SQL Server GKKNETSRV version 8.00.2039 (0 connection limit)
2006-04-06 03:15:04 - ? [102] SQL Server ODBC driver version 3.86.1830
2006-04-06 03:15:04 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2006-04-06 03:15:04 - ? [310] 4 processor(s) and 2048 MB RAM detected
2006-04-06 03:15:04 - ? [339] Local computer is GKKNETSRV running Windows NT 5.2 (3790) Service Pack 1
2006-04-06 03:15:04 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2006-04-06 03:15:04 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2006-04-06 03:15:04 - + [260] Unable to start mail session (reason: No mail profile defined)
2006-04-06 03:15:04 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2006-04-06 05:48:00 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2006-04-06 05:48:30 - ! [240] 1 engine thread(s) failed to stop after 30 seconds of waiting
2006-04-06 05:48:30 - ! [311] Thread 'ExternalRequestorEngine' (ID 12336) is still running
2006-04-06 05:48:31 - + [098] SQLServerAgent terminated (forcefully)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply