Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    L.A
    Posts
    3

    Wink Unanswered: SQL job step suddenly takes longer to complete

    Hey All, I have a large SQL job that runs nightly everyday. Recently though one of the steps is taking 6 hours to complete. This step usually has taken around 2 hours to complete. There were no changes made to the job or the step. I checked the server log for any unusual events that might have caused this but nothing. Any ideas why this is happening? Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    British Columbia
    Posts
    44
    What action does the job perform? If it does any queries, updates, inserts check your indexes.

    Were any other jobs, not related to this nightly process, added. It could be fighting for resources.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •