Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1295
  • Last Modified:

SQLSERVERAGENT

The Database Mail issue has been resolved, but I am still getting SQLSERVERAGENT with event ID 319 errors how do I resolves this?  
0
WTRog
Asked:
WTRog
  • 3
1 Solution
 
Eugene ZCommented:
there is not much info in your question..
however, for start check solution:

http://itknowledgeexchange.techtarget.com/itanswers/consistent-error-occuring-in-sql-server-2005/
0
 
WTRogAuthor Commented:
Below is the information I have from the Server MP2-Server.  I had an issue earlier with no alert e-mail being sent but was resolved.  Under the SQLSERVERAGENT I have my different jobs set to run which are running as scheduled and sending alerts e-mails.  I am just not certain why I am receiving the error in Event Viewer.

Source: SQLSERVERAGENT
Category: Alert Engine
Event ID: 319

Cyclical forwarding detected for event 5084:  Event source MP2-Server which matches the current forwarding server.  The event was not forwarded.

Source: MSSQLSERVER
Category: (2)
Event ID: 5084

Setting database option to RECOVERY to SIMPLE for database PRODUCTION.
0
 
WTRogAuthor Commented:
SQL Server Agent was set to forward to itself so I unchecked that option, so lets see what happens.
0
 
WTRogAuthor Commented:
Thank you
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now