estimate finish time for a maintenece job

• rajsin7786

  Right there with Babe

  Points: 718

  More actions

  May 9, 2014 at 8:51 am

  #285400

  hello friends,

  I have an index rebuild job and just kick started it now. is there any way to find out what would be the estimated completion time of this job?

  Thanks

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  May 9, 2014 at 12:05 pm

  #1712292

  The "sp_whoisactive" tool show % complete. Not sure how accurate it is.

• ninad.soman0

  Ten Centuries

  Points: 1111

  More actions

  May 19, 2014 at 5:50 am

  #1714584

  Hi,

  See if this helps

  a. Find the session id of the dbcc command being run.

  b. Use the session id below -

  select percent_complete from sys.dm_exec_requests where session_id=xxx

  The percent complete returns the % of work completed for most of the tasks being performed.

  It can be used to find the backup, restore rollback % as well.

  You might want to return some othet columns in the query.

  Detailed read available at -

  Regards