"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

"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
>
>

"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
>>
>>
>
>

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