Post reply

SQL Admin Newbie - SQL Server Agent

  • December 13, 2004 at 3:19 pm

    #361711

    I've tried to setup a Maintenance Plan that will backup my DB daily. However, I have not had any luck with the backup job executing. I can backup the DB manually.

    I just noticed that the SQL Agent is stopped. Does this have any effect on the DB backup job?

     

     

  • December 13, 2004 at 3:30 pm

    #533660

    Yep.  SQL Agent handles all the scheduling within SQL.  It must be running for any automated job to execute via its schedule.

    Steve

  • December 13, 2004 at 3:43 pm

    #533664

    Thanks. I'll see if this does the trick.

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

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