• coolchaitu - Monday, December 4, 2017 10:03 AM

  • Good Morning Experts
  • One  of our jobs is getting stuck everytime it is triggered in UAT. The same ,job is running fine in prod. The job runs sql code.Could you please let me know how to approach this issue,why is job getting stuck each time it is being triggered in UAT
  • Step one, of course, would be to define what you mean by "getting stuck".  Is it the job that's getting stuck because of something wonky on the server or is it the code in the job that's getting stuck?  Did someone mess up and shrink the database which will cause these types of symptoms?  Does the code have a "spill to disk"  somewhere because the system is underpowered compared to the production box?  Like Lynn asked, does the code in the job run correctly if you run it from SSMS without the job?  Are stats up to date?  Etc, etc, etc.  Start somewhere and expand.  First thing to do is make sure that the code the job is running runs fine without the job.

    --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)