Post reply

SQL JOB takes too much time to execute

  • January 8, 2014 at 11:52 pm

    #280942

    Hi,

    I created one job, when execute it it takes around 9 hours and when i manually executes that sp which is used in job than only takes 1 min.

    So why this happens ?

    Please reply. it will be helpful,

    Thanks in advanced.

  • January 9, 2014 at 5:01 am

    #1678740

    read something about parameter sniffing.

    put your code if its possible

  • January 9, 2014 at 6:29 am

    #1678760

    Is this problem reproducable? Does it occur when the job is scheduled to run at a different moment? Are other processes running at the same moment (could cause blocking issues)?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • January 9, 2014 at 10:12 am

    #1678872

    What time does the job run and what time are you testing your code?

    Is anything else running when the job runs (scheduled)?

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

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