/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 vote225 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote222 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote211 views1 answer
Call function sql oracle
SQL
16 votes216 views1 answer
Mssql int max value
SQL
0 vote217 views1 answer
Oracle sql alter view add column
SQL
0 vote258 views1 answer
Pagination with row_number
SQL
0 vote243 views1 answer
Mysql collation portugues brasil
SQL
0 vote238 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote224 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
150 votes368 views10 answers
Grepper
SQL