Post reply

sql agent - job manager stuck..

  • June 3, 2003 at 2:36 pm

    #159227

    HI..I recently started having problems with my automated backup jobs. the backups themselves execute successfully but the part that the sql agent - job manager plays, hangs and just sits in EM..if i stop and start the agent the process goes away. But the next time a schedule job executes, the process will just sit there and when i double click on the process this is what appears:

    SELECT id, name, enabled, email_address, pager_address, netsend_address, weekday_pager_start_time, weekday_pager_end_time, saturday_pager_start_time, saturday_pager_end_time, sunday_pager_start_time, sunday_pager_end_time, pager_days FROM msdb.dbo.sysoper

    Now, if i reboot the server, then all is well again and the scheduled jobs have no hang up problems at all and then at some point the problem begins again.

    Any clue?

    Juanita

  • June 3, 2003 at 3:50 pm

    #459615

    strange. sounds like a bug somewhere. Is this ss2k? service pack?

    Steve Jones

    sjones@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • June 3, 2003 at 3:55 pm

    #459617

    Steve,

    It is sql server 2000 standard edition, service pack 2. I feel like this started when we changed our email to microsoft exchange server but i can't say for sure. I checked my server logs and event viewew on the NT 4.0 server box and no messages. I guess I can reboot the box again and take notice when it occurs and go from there. Could it be from jobs running too close to each other in the schedules?

  • June 4, 2003 at 7:25 am

    #459721

    Last night I rebooted the box that sql runs on and all the backups completed successfully from beginning to end. no processes left running. BUT on my test box i have a process hanging just like on the production box. what i also noticed is that in sql agent in the listing of JOBS, on the line for the job that is hanging it says that the job status is PERFORMING COMPLETION ACTIONS. If i look at the last tsql command executed it it the EXACT same select clause that the production job was stoppig on.

    i'm totally lost on this one. I did find out that our arcserv backup software is not working correctly but our network person said it quits working before it reaches the sql box. i thought maybe that was the problem.

    juanita

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

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