SQL Agent gets stopped.

  • Hi,

    Daily Full Backup Jobs+Transaction Log Backups+Job Maintainence Plan stops since the SQL Agent gets stopped.

    Have to refresh the same manully even though the SQL Service Managaer is Auto-Start.

    Can Anyone help me out on this.

    Regards

    Syed

  • First, please post in the appropriate forum and give your version. Moving this to 2005 admin.

    Second, you need to check the SQL server logs and look for the reason that the Agent stopped. It's a service like any other, and there could be some reason listed in the logs. The services applet also has the ability to restart services if they stop or send out a notification.

Viewing 2 posts - 1 through 2 (of 2 total)

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