Agent Log Files Empty

On Oct 8, 11:39 pm, "John Bell" <jbellnewspo....DeleteThis@hotmail.com> wrote:
> "Ian" <harding.....DeleteThis@gmail.com> wrote in message
>
> news:fe74dbf6-b278-4a07-a380-42abfc1eeb9a@g25g2000prf.googlegroups.com...
>
> >I have an odd problem.  The SQL Server Agent log files are all zero
> > length.  There should be at least a few records, as I have provoked
> > them, but nothing is logged.  Permissions all seem to be fine, the
> > files are created when the service is restarted, and the files roll
> > over, but they are all empty.
>
> > I have fooled around with the "Include Execution Trace Messages"
> > setting, renamed the log file, and everything works just fine, but no
> > logging.
>
> > Main SQL Server error log is fine.
>
> > Any ideas!
>
> Hi Ian
>
> The agent log should have some start up messages so it will always have some
> size. Is SQL Agent running under an domain account or not? Have you tried
> changing it?
> Is there anything in the Windows Event Log?
>

It's running under a domain account, with Full Control on the SQL
Server NTFS tree. It creates, renames and deletes the logfiles, they
are all zero length. filemon.exe does not show it even trying to
write. Nothing in the Event Log or the SQL Server log.

> If this is a corrupt dll you would to know which one and replace it or
> install a service pack/hotfix that will replace it.
>

I figure that's what it must be, since there is nothing in any other
error logs to indicate a problem...

Thanks...

- Ian
 >> Stay informed about: Agent Log Files Empty