SQLServerAgent crash 
Author Message
 SQLServerAgent crash

Hi

Did anyone hear of this?
When a job that is scheduled to run one time is executed,
SQLServerAgent crashes (at least for scripting and
commmand line jobs).
After this the SQLServerAgent is unable to start unless I
delete the job.
In the Event Log I found this:

Tipo evento:    Errore
Origine evento: SQLSERVERAGENT
Categoria evento:       None
ID evento:      51
Data:           11/04/2003
Ora:            09:00:21
Utente:         N/D
Computer:       SILICONATURE02
Descrizione:
Exception 5 caught at line 191 of file ..\src\refreshr.c.  
SQLServerAgent initiating self-termination.

SQLServer 2000 Standard Edition SP3 on Windows 2000
Advanced Server SP3

Thanks



Tue, 27 Sep 2005 16:29:40 GMT
 SQLServerAgent crash

Looks like this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;289472

--

Andrew J. Kelly
SQL Server MVP


Quote:
> Hi

> Did anyone hear of this?
> When a job that is scheduled to run one time is executed,
> SQLServerAgent crashes (at least for scripting and
> commmand line jobs).
> After this the SQLServerAgent is unable to start unless I
> delete the job.
> In the Event Log I found this:

> Tipo evento: Errore
> Origine evento: SQLSERVERAGENT
> Categoria evento: None
> ID evento: 51
> Data: 11/04/2003
> Ora: 09:00:21
> Utente: N/D
> Computer: SILICONATURE02
> Descrizione:
> Exception 5 caught at line 191 of file ..\src\refreshr.c.
> SQLServerAgent initiating self-termination.

> SQLServer 2000 Standard Edition SP3 on Windows 2000
> Advanced Server SP3

> Thanks



Tue, 27 Sep 2005 20:51:45 GMT
 SQLServerAgent crash
Actually I found on KB something even more like my
problem, but for SQLServer pre-SP3.
But this server has the latest SP, SP3.

Quote:
>-----Original Message-----
>Looks like this:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;289472

>--

>Andrew J. Kelly
>SQL Server MVP



Tue, 27 Sep 2005 21:42:16 GMT
 SQLServerAgent crash
If this has the latest sp and you still get that kind of error you should
call MS PSS.  If it's a bug (and it sounds likely) you will be refunded.  If
not, they will still help you fix it.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql    SQL Support
http://www.mssqlserver.com/faq/general-pss.asp   MS PSS
--

Andrew J. Kelly
SQL Server MVP


Quote:
> Actually I found on KB something even more like my
> problem, but for SQLServer pre-SP3.
> But this server has the latest SP, SP3.

> >-----Original Message-----
> >Looks like this:
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;289472

> >--

> >Andrew J. Kelly
> >SQL Server MVP



Tue, 27 Sep 2005 21:48:53 GMT
 SQLServerAgent crash

Thanks

Quote:
>-----Original Message-----
>If this has the latest sp and you still get that kind of
error you should
>call MS PSS.  If it's a bug (and it sounds likely) you

will be refunded.  If
Quote:
>not, they will still help you fix it.

>http://support.microsoft.com/default.aspx?scid=fh;EN-

US;sql    SQL Support
Quote:
>http://www.mssqlserver.com/faq/general-pss.asp   MS PSS
>--

>Andrew J. Kelly
>SQL Server MVP



Tue, 27 Sep 2005 21:55:12 GMT
 SQLServerAgent crash
hi Lucian,
this seems to be another problem regardin Italiang localization of SQL
Server 2000..
I've found other 3 issues regarding SQL Agent crashes....
I've addressed my troubles to Lorenzo Benaglia, an MVP reading on italian
Sql Server news group... (microsoft.public.it.sql)
he will contact internal MVPs channels in order to report these "features"
to SQL dev team..
hth
Andrea Montanari

http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.3.1  -  DbaMgr ver 0.49.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply


Quote:

> Thanks

> >-----Original Message-----
> >If this has the latest sp and you still get that kind of
> error you should
> >call MS PSS.  If it's a bug (and it sounds likely) you
> will be refunded.  If
> >not, they will still help you fix it.

> >http://support.microsoft.com/default.aspx?scid=fh;EN-
> US;sql    SQL Support
> >http://www.mssqlserver.com/faq/general-pss.asp   MS PSS
> >--

> >Andrew J. Kelly
> >SQL Server MVP



Tue, 27 Sep 2005 22:13:50 GMT
 SQLServerAgent crash

Interesting. I didn't think to mention the language.
If there are more problems, then perhaps they'll be kind
enough to pay attention. :)
I was hoping for a workaround...
Thanks

Quote:
>-----Original Message-----
>hi Lucian,
>this seems to be another problem regardin Italiang
localization of SQL
>Server 2000..
>I've found other 3 issues regarding SQL Agent crashes....
>I've addressed my troubles to Lorenzo Benaglia, an MVP
reading on italian
>Sql Server news group... (microsoft.public.it.sql)
>he will contact internal MVPs channels in order to report
these "features"
>to SQL dev team..
>hth
>Andrea Montanari

>http://www.asql.biz/DbaMgr.shtm
>DbaMgr2k ver 0.3.1  -  DbaMgr ver 0.49.1
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>--------- remove DMO to reply



Tue, 27 Sep 2005 22:27:43 GMT
 SQLServerAgent crash
hi,
none that I'm aware of....
Italian localization of SQL Server Agent 2000 sp3 actually crashes in the
following situations:

-  a blocking problem and refers to multisteps jobs started by user that
make SQL Agent hang.
   This behavior is exhibited by SQL-Dmo, Enterprise Manager and T-SQL
commans run via
   Query Analyzer.

- another blocking one and refers to Schedules occurring "One Time on date
xx at time xx" that
  chrash SQLServer Agent with no error reported in SQLAgent.Out file and
jobs with this kind of
  schedule are not executed.

- a minor "cosmetic" problem, that's to say it's not a blocking problem:
   The Backup/Restore objects exposed by SQL-Dmo object model, always raise
an
   object_PercentComplete event where Percent parameter is 0 (zero) and
Message parameter is
   not complete;
   Enterprise Manager exhibits the same behavior, the progress bar does not
increment it's position.

Andrea Montanari

http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.3.1  -  DbaMgr ver 0.49.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply


Quote:

> Interesting. I didn't think to mention the language.
> If there are more problems, then perhaps they'll be kind
> enough to pay attention. :)
> I was hoping for a workaround...
> Thanks

> >-----Original Message-----
> >hi Lucian,
> >this seems to be another problem regardin Italiang
> localization of SQL
> >Server 2000..
> >I've found other 3 issues regarding SQL Agent crashes....
> >I've addressed my troubles to Lorenzo Benaglia, an MVP
> reading on italian
> >Sql Server news group... (microsoft.public.it.sql)
> >he will contact internal MVPs channels in order to report
> these "features"
> >to SQL dev team..
> >hth
> >Andrea Montanari

> >http://www.asql.biz/DbaMgr.shtm
> >DbaMgr2k ver 0.3.1  -  DbaMgr ver 0.49.1
> >(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
> MSDE 2000 a visual
> >interface)
> >--------- remove DMO to reply



Wed, 28 Sep 2005 01:17:18 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. If one DBE application crashes, they all crash...

2. DOA app crashes with a Kernel Crash on exit

3. Start SQLServerAgent Service Problem

4. Auto Start SQLServerAgent

5. SQLServerAgent Will not start

6. sqlserverAgent failing

7. Starting Synchronous 'Child' Jobs within SQLServerAgent

8. SQLServerAgent Won't Start After 6.5 to 7.0 Upgrade

9. Start SQLServerAgent on a Win 95/98/ME from command line/programatically

10. SqlServerAgent

11. SQLServerAgent Mail

12. SQL Server not able to open SQLServerAgent


 
Powered by phpBB® Forum Software