'Get status of each step running in job in SQL agent

I need some help to get the status of each step in job (not in job activity) in SQL Server agent using sys tables. I am trying get the information but not able to find the related tables.

Could someone help the tables where all this information is stored as job name, step name, status whether it is running or failed or success.

Thanks

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions