/SQL/Ms sql how to see active job current run time

Ms sql how to see active job current run time

SELECT
    ja.job_id,
    j.name AS job_name,
    ja.start_execution_date,      
    ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id,
    Js.step_name
FROM msdb.dbo.sysjobactivity ja 
LEFT JOIN msdb.dbo.sysjobhistory jh 
    ON ja.job_history_id = jh.instance_id
JOIN msdb.dbo.sysjobs j 
ON ja.job_id = j.job_id
JOIN msdb.dbo.sysjobsteps js
    ON ja.job_id = js.job_id
    AND ISNULL(ja.last_executed_step_id,0)+1 = js.step_id
WHERE ja.session_id = (SELECT TOP 1 session_id FROM msdb.dbo.syssessions ORDER BY agent_start_date DESC)
AND start_execution_date is not null
AND stop_execution_date is null;

Source: dba.stackexchange.com

Similar codes

0 vote313 views1 answer
Remove binlog mysql
SQL
4 votes298 views2 answers
Mysql how to change default charset
SQL
2 votes301 views1 answer
Add new column not null sql server
SQL
0 vote348 views1 answer
Min varias colunas spark sql
SQL
-2 votes313 views2 answers
Union vs union all in sql
SQL
0 vote291 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
-1 vote301 views1 answer
What is in operator
SQL
0 vote295 views1 answer
Search In the Data using ObjectName
SQL
1 vote317 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
5 votes315 views2 answers
Get number of columns sql
SQL