/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

10 votes195 views2 answers
Show tables in schema oracle
SQL
5 votes176 views1 answer
Ora-00054 find lock
SQL
1 vote175 views1 answer
Mysql login console
SQL
0 vote208 views1 answer
Postgresql show owner of database
SQL
1 vote191 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote212 views2 answers
How to get max from each department in sql
SQL
0 vote174 views1 answer
Sql random decimal
SQL
0 vote210 views1 answer
Sql query use select name inside where clause
SQL
0 vote266 views1 answer
<sql:datasource var="Snapsho"
SQL
-1 vote183 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL