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
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
Good One Bala ...
ReplyDeletethanks you chandra..
ReplyDelete