Restart SSA in a job?

  • Hi,

    I have a job that rebuilds indexes after a refresh of a replicated report DB.

    The issue is sometime I need to restart the SQL Server Agent to get it to start. Is there a command I can use to first restart it?

     

    Thanks

     

  • Can you explain further?  How exactly are you refreshing this? Backup and restore? Replication Snapshot? Something else?

    Once the process completes, you then run a re-index process.  Why? Are the indexes fragmented?

    That process then causes the SQL Agent to stop? Or does the agent never start after a re-boot?  In either case, determining the cause of the agent being stopped or not starting is what I would focus on.

    Otherwise, you can use the NET START command to start the service.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

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

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