/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

8 votes343 views1 answer
Alter tablespace add datafile
SQL
8 votes354 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote333 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote361 views1 answer
Xampp increame mysql speed
SQL
0 vote356 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote371 views2 answers
Import .sql into postgres db command
SQL
2 votes392 views2 answers
Create table mysql integer NOT null
SQL
0 vote364 views1 answer
Case insensitive sql
SQL
0 vote401 views1 answer
Fetching data from mysqldb
SQL
0 vote366 views1 answer
Show the colums of table sql
SQL