Re: Autostart MS Agent on Win98/Me

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 11:12:49 -0000

Right. Seems Win9x is a bit too long ago for me. I better not answer any
more questions that involve Win 9x :) 

-- 
Jacco Schalkwijk
SQL Server MVP
"Gert E.R. Drapers" <GertD@SQLDev.Net> wrote in message 
news:eyuMfi09EHA.1544@TK2MSFTNGP11.phx.gbl...
> That will never work on Windows 9x based OS's since there is no concept of 
> a real service which gets started with NET START. Only Windows NT based 
> OS's (and OS/2) have NET START.
>
> You can use SCM.EXE instead
>
> GertD@SQLDev.Net
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no 
> rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2004 All rights reserved.
>
> "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> 
> wrote in message news:eU1Ed3y9EHA.2876@TK2MSFTNGP12.phx.gbl...
>> If you really rely on SQL Server Agent being started and you have not a 
>> lot of control over the machine, start SQL Server Agent from within SQL 
>> Server:
>>
>> -- Create a procedure to start SQL Server Agent
>> USE master
>> GO
>> CREATE PROC usp_start_sqlserveragent
>> AS
>> EXEC master..xp_cmdshell 'net start SQLServerAgent'
>> GO
>> -- Mark stored procedure to run on SQL Server start
>> EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
>>
>> -- 
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>>
>> "Allcomp" <marc@nospam.allcomp.be> wrote in message 
>> news:41e279f2$0$2676$ba620e4c@news.skynet.be...
>>> Hello,
>>>
>>> does anyone know how I could autostart the MSAgent on Win98/Me with a 
>>> named instance.
>>>
>>> I try with
>>> scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
>>>
>>> where str_InstanceName is the name of the MSDE Instance.
>>> The password is correct (I exported the crypted password from a computer 
>>> with Entreprise manager and the agent start with WinNT...
>>> It can also start manually.
>>> On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message 
>>> Service operation has been completed successfully but the agent did not 
>>> start. I can manually start the agent with the MSDE service manager, but 
>>> if my custommer forget it then he has no automatic backup of his 
>>> database.
>>>
>>>
>>>
>>> Thank you
>>> Marc Allard
>>> Allcomp
>>
>>
>
>

Relevant Pages

  • Re: Autostart MS Agent on Win98/Me
    ... If you really rely on SQL Server Agent being started and you have not a lot ... > with Entreprise manager and the agent start with WinNT... ... I can manually start the agent with the MSDE service manager, ...
    (microsoft.public.sqlserver.msde)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... Right Click on the SQL Server Agent icon in EM and choose properties. ... > How do I determine which account was used to start SQL Agent? ... >> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Win 2003 upgrade
    ... Then I would start it up SQL Server agent and see if I can't identify the ... For the problem with the retention period of expiring subscribers, ... 'The subscription has not been synchronized within the maximum ...
    (microsoft.public.sqlserver.replication)