Autostart SQLServerAgent service

Hi,
During our server installation SQL Server 2000 SP4 SQLServerAgent is
not started (it was also not needed). But since a few weeks we are
using SQL jobs to make a SQL Backup very day
My first actions were:
SC CONFIG sqlserveragent start=3D auto
and
NET START sqlserveragent
I thought this was enough, but...
After a boot (weekly boot) the SQLServerAgent service was stopped and
configured manual... and thus the backup was not made!
For the moment I now have the following workaround:
CREATE PROCEDURE dbo.PRXAutoAgent
AS
EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
GO
--Set new stored procedure as start up stored procedure
EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
GO
Everytime the server boots and SQLServer is starting up, the stored
procedure 'PRXAutoAgent' is started.
My question(s): how is it possible that every time the server boots the
SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
Is there a solution to this problem?
Hope to hear,
Andr=E9Hi
Go to the Services on the server and Start the Agent in automatic regime
"DrDre" <avwg@.planet.nl> wrote in message
news:1163487650.945207.264300@.k70g2000cwa.googlegroups.com...
Hi,
During our server installation SQL Server 2000 SP4 SQLServerAgent is
not started (it was also not needed). But since a few weeks we are
using SQL jobs to make a SQL Backup very day
My first actions were:
SC CONFIG sqlserveragent start= auto
and
NET START sqlserveragent
I thought this was enough, but...
After a boot (weekly boot) the SQLServerAgent service was stopped and
configured manual... and thus the backup was not made!
For the moment I now have the following workaround:
CREATE PROCEDURE dbo.PRXAutoAgent
AS
EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
GO
--Set new stored procedure as start up stored procedure
EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
GO
Everytime the server boots and SQLServer is starting up, the stored
procedure 'PRXAutoAgent' is started.
My question(s): how is it possible that every time the server boots the
SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
Is there a solution to this problem?
Hope to hear,
André|||Hi Uri,
This was known to me and done/tested by me, but still, after a boot the
SQLServerAgent doesnot run and is configured manual..
Andr=E9
Uri Dimant wrote:
> Hi
> Go to the Services on the server and Start the Agent in automatic regime
>
> "DrDre" <avwg@.planet.nl> wrote in message
> news:1163487650.945207.264300@.k70g2000cwa.googlegroups.com...
> Hi,
> During our server installation SQL Server 2000 SP4 SQLServerAgent is
> not started (it was also not needed). But since a few weeks we are
> using SQL jobs to make a SQL Backup very day
> My first actions were:
> SC CONFIG sqlserveragent start=3D auto
> and
> NET START sqlserveragent
> I thought this was enough, but...
> After a boot (weekly boot) the SQLServerAgent service was stopped and
> configured manual... and thus the backup was not made!
> For the moment I now have the following workaround:
> CREATE PROCEDURE dbo.PRXAutoAgent
> AS
> EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
> GO
> --Set new stored procedure as start up stored procedure
> EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
> GO
> Everytime the server boots and SQLServer is starting up, the stored
> procedure 'PRXAutoAgent' is started.
> My question(s): how is it possible that every time the server boots the
> SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
> > Is there a solution to this problem?
> > Hope to hear,
> > Andr=E9|||DrDre
>This was known to me and done/tested by me, but still, after a boot the
>SQLServerAgent doesnot run and is configured manual..
Any info in Event Viewer ,ERROR.LOG?
"DrDre" <avwg@.planet.nl> wrote in message
news:1163492345.735336.128170@.i42g2000cwa.googlegroups.com...
Hi Uri,
This was known to me and done/tested by me, but still, after a boot the
SQLServerAgent doesnot run and is configured manual..
André
Uri Dimant wrote:
> Hi
> Go to the Services on the server and Start the Agent in automatic regime
>
> "DrDre" <avwg@.planet.nl> wrote in message
> news:1163487650.945207.264300@.k70g2000cwa.googlegroups.com...
> Hi,
> During our server installation SQL Server 2000 SP4 SQLServerAgent is
> not started (it was also not needed). But since a few weeks we are
> using SQL jobs to make a SQL Backup very day
> My first actions were:
> SC CONFIG sqlserveragent start= auto
> and
> NET START sqlserveragent
> I thought this was enough, but...
> After a boot (weekly boot) the SQLServerAgent service was stopped and
> configured manual... and thus the backup was not made!
> For the moment I now have the following workaround:
> CREATE PROCEDURE dbo.PRXAutoAgent
> AS
> EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
> GO
> --Set new stored procedure as start up stored procedure
> EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
> GO
> Everytime the server boots and SQLServer is starting up, the stored
> procedure 'PRXAutoAgent' is started.
> My question(s): how is it possible that every time the server boots the
> SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
> Is there a solution to this problem?
> Hope to hear,
> André|||Uri,
Nope, looked there--> no errors :-(
No problems at all, except a non-running SQLServerAgent after a boot
Uri Dimant wrote:
> DrDre
> >This was known to me and done/tested by me, but still, after a boot the
> >SQLServerAgent doesnot run and is configured manual..
> Any info in Event Viewer ,ERROR.LOG?
>
> "DrDre" <avwg@.planet.nl> wrote in message
> news:1163492345.735336.128170@.i42g2000cwa.googlegroups.com...
> Hi Uri,
> This was known to me and done/tested by me, but still, after a boot the
> SQLServerAgent doesnot run and is configured manual..
> Andr=E9
> Uri Dimant wrote:
> > Hi
> > Go to the Services on the server and Start the Agent in automatic regime
> >
> >
> >
> > "DrDre" <avwg@.planet.nl> wrote in message
> > news:1163487650.945207.264300@.k70g2000cwa.googlegroups.com...
> > Hi,
> >
> > During our server installation SQL Server 2000 SP4 SQLServerAgent is
> > not started (it was also not needed). But since a few weeks we are
> > using SQL jobs to make a SQL Backup very day
> >
> > My first actions were:
> > SC CONFIG sqlserveragent start=3D auto
> > and
> > NET START sqlserveragent
> >
> > I thought this was enough, but...
> >
> > After a boot (weekly boot) the SQLServerAgent service was stopped and
> > configured manual... and thus the backup was not made!
> >
> > For the moment I now have the following workaround:
> >
> > CREATE PROCEDURE dbo.PRXAutoAgent
> > AS
> > EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
> > GO
> > --Set new stored procedure as start up stored procedure
> > EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
> > GO
> > Everytime the server boots and SQLServer is starting up, the stored
> > procedure 'PRXAutoAgent' is started.
> >
> > My question(s): how is it possible that every time the server boots the
> > SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
> >
> > Is there a solution to this problem?
> >
> > Hope to hear,
> >
> > Andr=E9|||"DrDre" <avwg@.planet.nl> wrote in message
news:1163492345.735336.128170@.i42g2000cwa.googlegroups.com...
Hi Uri,
This was known to me and done/tested by me, but still, after a boot the
SQLServerAgent doesnot run and is configured manual..
Confirm in the SERVICES Applet in the control panel that SQL Server Agent is
set to automatic and depends on SQL Server.
André
Uri Dimant wrote:
> Hi
> Go to the Services on the server and Start the Agent in automatic regime
>
> "DrDre" <avwg@.planet.nl> wrote in message
> news:1163487650.945207.264300@.k70g2000cwa.googlegroups.com...
> Hi,
> During our server installation SQL Server 2000 SP4 SQLServerAgent is
> not started (it was also not needed). But since a few weeks we are
> using SQL jobs to make a SQL Backup very day
> My first actions were:
> SC CONFIG sqlserveragent start= auto
> and
> NET START sqlserveragent
> I thought this was enough, but...
> After a boot (weekly boot) the SQLServerAgent service was stopped and
> configured manual... and thus the backup was not made!
> For the moment I now have the following workaround:
> CREATE PROCEDURE dbo.PRXAutoAgent
> AS
> EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'
> GO
> --Set new stored procedure as start up stored procedure
> EXEC dbo.sp_procoption 'PRXAutoAgent', 'startup','TRUE'
> GO
> Everytime the server boots and SQLServer is starting up, the stored
> procedure 'PRXAutoAgent' is started.
> My question(s): how is it possible that every time the server boots the
> SQLServerAgent service is reconfigured? Is it Windows Server 2003 SP1'
> Is there a solution to this problem?
> Hope to hear,
> André