Back to Geneos FAQ

How to query SQL Server Agent Jobs

Based on the SQL Server Job queries from this link with minor updates to convert some data types, the SQL-Toolkit plug-in can be configured to retrieve Job setup, execution and scheduled information. The sampler xml file is attached at the bottom of the page. Below are examples of these Job dataviews:

Related downloads Copied

• SQLServer_Agent_Jobs-Sampler.xml