/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

17 votes129 views6 answers
Mysql import sql file
SQL
1 vote149 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote132 views1 answer
Intellij mysql set timezone
SQL
0 vote143 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote146 views1 answer
Sql server kill all connections
SQL
0 vote145 views3 answers
Sql query checker
SQL
1 vote162 views1 answer
Homebrew install mysql
SQL
5 votes138 views2 answers
Sql constraint check value in list
SQL
0 vote134 views1 answer
Select the date 30 days less that the todays date sql request
SQL
4 votes145 views1 answer
Oracle nls_date_format
SQL