Post reply

Need information on clustering and/or troubleshooting jobs

  • October 16, 2007 at 6:48 am

    #742325

    there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way security and the service accounts are set up. I've never really fond any differences working with clusters - but it does depend if the server has been configured correctly - it's always best to have the lastest servcie packs installed - especially with sql 2005 which hasn't been very good - you'd need porbably the latest rollup for sp2 too - last thing I'd do is run in sp2 alone.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 16, 2007 at 9:19 am

    #742417

    colin Leversuch-Roberts (10/16/2007)

    there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way security and the service accounts are set up. I've never really fond any differences working with clusters - but it does depend if the server has been configured correctly - it's always best to have the lastest servcie packs installed - especially with sql 2005 which hasn't been very good - you'd need porbably the latest rollup for sp2 too - last thing I'd do is run in sp2 alone.

    Thanks. Yes, it does seem like we need to go to SP2. We are running SP1 now, and I wonder whether the SQL Server Agent problems and the problem with the file deletion stored procedure I'm seeing are due to the service pack lag.

    I'll post the results after the changes.

    Thanks again,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

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

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