Re: Autostart MS Agent on Win98/Me

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

Date: Mon, 10 Jan 2005 16:02:58 -0000

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
    ... Only Windows NT based OS's ... > lot of control over the machine, start SQL Server Agent from within SQL ... 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)