(Urgent) Sql Server Agent Stopped Automatically after sometime

  • 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

  • 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.

     

     

  • 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

  • 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

  • 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