Re: Jobs Not run but sql server agent is started.

Hi,
The jobs run fine some times, then they not run simply, they not work more.
I have restart the service to the jobs run again.


"Uri Dimant" wrote:

Carlos
You said
I have Sql server 2000 Enterprise Ed run over Windows 2000 Advance Server
with sp4, some times, jobs not run, but sql server agent is running.

But now you are saing
Yes all jobs are enable, the problem is thal all jobs run o.k, but



"Carlos A." <CarlosA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:40EF98B1-4B8E-43B9-9E98-696CE58B4683@xxxxxxxxxxxxxxxx
Hi,
Yes all jobs are enable, the problem is thal all jobs run o.k, but then
they
leave of run. there are No errors, in a sql server error log, or in a sql
server agent error log, or in an event viewer. And sql server agent is
running

Some idea?

Thanks a lot four your help

Carlos A.


"Uri Dimant" wrote:

Carlos
Does the job have a status "Enabled" --YES

Any errors in Event Viewer ? SQL Server ERROR.LOG file?

"Carlos A." <CarlosA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D490861-2C7F-4833-AC9F-23CD5C0E4D9C@xxxxxxxxxxxxxxxx
hi again,
sorry, SQL server agent does'nt report errors....

Carlos A.

"Carlos A." wrote:

Hi,
I have Sql server 2000 Enterprise Ed run over Windows 2000 Advance
Server
with sp4, some times, jobs not run, but sql server agent is running.
SQL
Server Agent report errors, is very stranger, because SQL Server
Agent
is
like "frozen".

Some any ideas?

Thanks a lot for you help.








.

Relevant Pages