/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 vote351 views1 answer
Gcloud sql list databases
SQL
2 votes286 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote324 views1 answer
Oracle turn off constraint
SQL
0 vote318 views1 answer
Sql count more than 1
SQL
0 vote323 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote311 views1 answer
Sql server port 1434
SQL
5 votes328 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes332 views1 answer
How to delete columns in sql
SQL
1 vote304 views1 answer
Median mysql
SQL
0 vote317 views1 answer
Alter fedora mysql 8.0 user
SQL