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

  • 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 1 month, 3 weeks ago by  xiaoluma.
    • This topic was modified 1 month, 3 weeks ago by  xiaoluma.
  • 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

  • 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