Post reply

jobs getting delay in processing the data

  • May 26, 2015 at 3:51 am

    #148744

    jobs getting delay in processing the

    server A and server Bare in a environment

    1] from sever A to sever B a job is scheduled and through this the data processing will be done

    and it will insert the tables updated data from server A to server B

    2] while this process is happening jobs will be running in server B 1] insert job and 2]update job 3] data-cleaning job running in server B

    [ which helps the data to be inserted and automatically cleaned in server B which is previous data which it has stored from server A ]

    3] A delay in the data-cleaning job [used to delete the old data from server B ]is happening some times and while we check the alert mails which are configured regularly, some times

    a heavy load is happening and data-cleaning job alert throwing huge amount of records which is causing delay late response to Run this job

    in these case what should we do to rectify and areas to improve by that the delay should not happen and the cleanup jobs should run frequently and also it should delete the records frequently

    Thanks
    Naga.Rohitkumar

  • May 27, 2015 at 12:06 am

    #1800752

    Hard to tell with the info you've given. The best I can offer is that you need to continue to work to find the code that is causing the delay and fix it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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