Post reply

Restarting the SQL Agent

  • June 28, 2010 at 10:05 am

    #147702

    I was on a support call this morning for a third party app that uses SQL to store all the data. The technician had me edit the job under the SQL Server Agent that the app creates to change the schedule of how often it runs. After makig the change and saving the job he then asked me to re-start the SQL Server Agent. I told him that I can just restart this service in the middle of the day on a Production server. Do you really need to restart this service for a minor change to a job schedule? Is there somthing I'm missing that this step would do that I'm not aware of?

  • June 28, 2010 at 10:15 am

    #1185909

    I can't imagine why he thinks it would need to be restarted, for a simple job change like that

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • June 29, 2010 at 3:03 am

    #1186246

    not required to restart the sql agent for such job changes.

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • July 1, 2010 at 10:30 am

    #1187784

    For editing a job, you dont need to restart sql server agent

    Regards
    Sushant Kumar
    MCTS,MCP

  • July 2, 2010 at 6:31 am

    #1188138

    For a job change there NO reason for a restart!

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

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