/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 vote174 views1 answer
Declarative base sqlalchemy
SQL
0 vote175 views1 answer
Mysql order by rand limit 1 really slow
SQL
3 votes210 views2 answers
Funktion LOWER/UPPER sql
SQL
5 votes157 views2 answers
Add column postgres with default value
SQL
1 vote183 views1 answer
Mysql curdate between two dates
SQL
5 votes154 views1 answer
Sql first day of current year
SQL
0 vote173 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote163 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote171 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote184 views1 answer
How to access to mysql without root
SQL