Agent Job

dbo.sysjobs (Transact-SQL) Stores the information for each scheduled job to be executed by SQL Server Agent. This table is stored in the msdb database. dbo.sysjobsteps (Transact-SQL) Contains the information for each step in a job to be executed by SQL Server Agent. This table is stored in the msdb database. dbo.sysproxies (Transact-SQL) Defines attributes of a SQL Server Agent …

How to find SQL Server database job step info using T-SQL Read More »

The dbo.sysjobhistory is Contains information about the execution of scheduled jobs by SQL Server Agent in MSDB database. Additional function agent_datetime Reference https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/dbo-sysjobhistory-transact-sql?view=sql-server-ver15