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

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

  • Re: Jobs Not run but sql server agent is started.
    ... The jobs run fine some times, then they not run simply, they not work more. ... "Uri Dimant" wrote: ... with sp4, some times, jobs not run, but sql server agent is running. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLAgent Jobs Not Available after SP4 Applied
    ... weren't even allowed to see the jobs. ... developers can see the jobs, but now they can't view or edit any of the job ... Microsoft really locked down the security on the SQL Agent in SP4. ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Error 22022 SQLServerAgent not running??
    ... SQL Server Agent is a service used to run scheduled jobs, ... essentially 'runs' replication - replication is a series of jobs referred to ...
    (microsoft.public.sqlserver.replication)
  • Re: Package Sercurity Context
    ... Where does it get the context, ... DTS is client-side, so when using Enterprise ... If you schedule a package then you basically get the SQL Server Agent ...
    (microsoft.public.sqlserver.dts)
  • [NT] Arbitrary File Creation/Overwrite with SQL Agent Jobs
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... a low privileged user can create or overwrite arbitrary files on ... * Microsoft SQL Server version 2000 ... If the SQL Server Agent is running with Local SYSTEM privileges, ...
    (Securiteam)