Post reply

Estimated rollback completion: 0%. Estimated time remaining: 0 seconds

  • February 24, 2024 at 9:36 am

    #4384016

    Greetings!

    I have a process that has been running for over a day (normally it runs about 30 minutes), tried "Kill SPID", it shows "Commands completed successfully."

    but it is still running.

    tried "Kill Spid with StatusOnly", it shows "transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds."

     

    The sql statement is trying to extract data from linked oracle server. Our team only has select permission in the oracle server. So the code is written like this:

    Declare @query varchar(max)

    set @query = 'complex Select sql script'

    insert into #LocalTempTable

    Exec(@query) at [LinkedOracleServer]

    Re-start the sql service would be the last option.

    How do I stop/kill this query?

    Thanks.

    • This topic was modified 9 months ago by  xiaoluma.
    • This topic was modified 9 months ago by  xiaoluma.

  • February 24, 2024 at 4:12 pm

    #4384185

    I would have the Oracle DBA's try to kill the process on their side first.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • February 26, 2024 at 1:46 pm

    #4385037

    Thanks, Jeffrey.

    I was hoping I don't need to talk to the other team 🙂

    I was hoping they would have some process to automatically kill some hung process, but obviously they don't.

    A side question, since this is one step in a multi-step process in an agent job. And after I stopped the job, the job has been running fine. what would be the consequences (except the DBAs from the other team might yell at us) if I just left the hung process along?

    Thanks.

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

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