search

agent86ray / SQL-AGENT-JOB-DATA-MART

This project builds a data mart from the SQL Server Agent tables. It implements an increment load design and includes type 2 slowly changing dimension handling for jobs and job steps.
1 stars 0 forks source link

Refine calculation of remaining job steps #22

Open agent86ray opened 3 years ago

agent86ray commented 3 years ago

Stored procedure [dbo].[GET_ACTIVE_JOBS]

How much longer the current step runs on average is not included in the remaining time.