SQLSERVERAGENT Error

  • I have started getting an eventlog problem and I am unable find a source. It seems to happen randomly and always recovers. The events look like this:

    Event ID:318, Source SQLSERVERAGENT or SqlAgen$SBSMONITORING

    Description: Unable to read local eventlog (reason: The event log file has changed between read operations).

    -----------------Followed by-----------------

    Event ID:311, Source SQLSERVERAGENT or SqlAgen$SBSMONITORING

    Description: Attempting to to re-open the local eventlog...

    -----------------Followed by-----------------

    Event ID:312, Source SQLSERVERAGENT or SqlAgen$SBSMONITORING

    Description: Successfully re-opened the local eventlog - NOTE: Some events may have been missed.

    --------------------------------------------------------------------

    Normally I don't think that I would be so concerned, but I am having lots of other problems with Exchange and IIS. I would like to rule out anything that is not applicable to my other problems.

    Does anyone know what it happening? and more importantly, How do I fix it? and MOST importantly, would this be related to my Exchange and IIS issues?

    Thanks for any and all help\suggestions

    Bill Hazelwood

    Thank-you
    Iceman
    No trees were harmed in the sending of this message, however a large number of electrons were terribly inconvenienced.

  • It sounds like someone could have started that SqlAgen$SBSMONITORING Service?  Just a guess.

  • Yes, this is true.

    I have the following log errors:

    2004-09-28 13:46:06 - ? [129] SQLAgent$SBSMONITORING starting under Windows NT service control

    2004-09-28 13:46:06 - + [260] Unable to start mail session (reason: No mail profile defined)

    However, if I cannot enter a Mail profile in the Management->Sql Server Agent->Properties dialog. The section for Mail session is greyed out.

    How can I enable the 'Mail session' portion of the Properties dialog for the SQL Server Agent?

    Thanks

    Thank-you
    Iceman
    No trees were harmed in the sending of this message, however a large number of electrons were terribly inconvenienced.

  • Did you install a mail client on that server? Are the SQL Sever executables using a domain service account? Do you have the Exchange mailbox tied in with the service account?

    If the answer is yes, did you restart SQL Server? If the answer is no, you still have some more work to complete...

  • what does the SBSMonitoring do? why is it enabled ? I have a similar problem where a seperate database confilicts with the SBS monitoring, by turning this off everything works. I need to find the reason why.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply