Post reply

sql job running indefinitely

  • May 20, 2008 at 4:03 am

    #185807

    Hey i've noticed recently that a few of my job are running indefinitely but can't figure out why i have also read some forums on this but there seems to be no answer for it..

  • May 20, 2008 at 4:07 am

    #817674

    What do these jobs do? Maybe they are locking themselves mutually?

    Piotr

    ...and your only reply is slàinte mhath

  • May 20, 2008 at 4:22 am

    #817684

    Could it be replication jobs? I've also seen some monitoring tools creating jobs which will run continously.

    [font="Verdana"]Markus Bohse[/font]

  • May 20, 2008 at 4:45 am

    #817698

    Most of the jobs are for a data warehouse so they are doing ELT work and most of them are work off different tables and databases.

    This has only happen recently about 2 weeks ago there has been no update to the server either..

  • May 20, 2008 at 5:10 am

    #817712

    are the tasks within the jobs actually completing and the job is just not ending, or are the tasks still actuallyu running?

  • May 20, 2008 at 5:23 am

    #817723

    I can run the DTS package and it work fine, But the schedure job is not finishing it always seems to hang on the last step most of my last steps are to send a email..reporting failue or to send out a file to a a few people listed on a email address

  • May 20, 2008 at 6:11 am

    #817775

    Does your last step use SQL Mail?

    Matt

  • May 20, 2008 at 6:12 am

    #817776

    The problem seems to be the send email task of the job when its schedule to run it get stuck on this step..

  • May 20, 2008 at 6:19 am

    #817784

    Take a look at this KB Article:

    http://support.microsoft.com/kb/315886

    Scroll down and take a look at Q12, Q13 and Q14 in particular.

    I have seen this happen before when Outlook is waiting for User Input (which is never going to happen!).

    Matt.

  • May 20, 2008 at 6:51 am

    #817821

    Are you using DTS or SSIS?

    if you are using xp_sendmail - then it uses a mapi profile (user mailbox)

    Try logging into a server with this account and open outlook for this user and try send an email.

    I too have had a similar problem and the mailbox was full - on a 2000 server using mapi

    let us know

    Thanks

    Kevin

  • May 20, 2008 at 7:34 am

    #817871

    Thanks guys i'll have a look at both and let you know..

    Am using DTS packages but i've also some SSIS package also

Viewing 11 posts - 1 through 10 (of 10 total)

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