Post reply

SQL JOB HANGS

  • January 31, 2003 at 9:45 pm

    #63246

    I am facing problems in jobs which hangs on some steps sometimes and does not allow us to stop the job, it shows the status as executing in any of the steps of the job, and does not allow to stop unless and until we retstart the service, this is quite strange, it was not hapening previously, but has started nowdays, from last 2 days, does anyone know y it occurs. the job has Active x scripts and if u view the job history it shows that it is cancelled due to restart of the service.. Please any help into this matter would be appreciated.

    Regards

    Jay

  • February 2, 2003 at 6:30 pm

    #447776

    Jay,

    Not sure why you are having problems. But what i might do is query the sysprocesses table in master database. And then run dbcc inputbuffer(spid)(where spid is the id of that process) and see if you get some more information.

  • February 2, 2003 at 7:48 pm

    #447777

    Try copying the ActiveXScripts into seperate files and execute them at a command prompt. You'll probably find that the script is waiting for some sort of input.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

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

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