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

SQL Agent service behavior #9

Open agent86ray opened 4 years ago

agent86ray commented 4 years ago

SELECT TOP 1 * FROM msdb.dbo.syssessions ORDER BY [session_id] DESC;

-- 9 2020-09-28 05:36:51.820 -- restart -- 10 2020-10-03 08:32:15.033