Thursday, January 29, 2015

How to Find The % of Job completed

How to Find The % of Job completed 



SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],
B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],
B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM
msdb.dbo.sysjobs A, sys.dm_exec_requests B
WHERE  Job_id LIKE '052280DF-7799-46AB-A259-A522BB90FB01'
order by percent_complete desc,B.TOTAL_ELAPSED_TIME/60000 desc

Note:please replace the Job_id

2 comments:

  Redshift User          Administration 1.1         Add New Users   Amazon Redshift user accounts can only be created and dropped by a d...