How to query SQL Server Agent Jobs?
ERROR: SQL-TOOLKIT Fail - ct_connect(): user api layer: external error: The connection failed because of invalid or missing external configuration data.
How to solve "Fail - ct_connect(): directory service layer: internal directory control layer error: Requested server name not found."
Why am I seeing an SSL Security Error in my SQL-Toolkit Windows sampler
SQL-Toolkit "Fail - 42000 Login failed for user" Error
How to solve the Sybase client error "cs_ctx_alloc -> CS_FAIL"
How to resolve error: Fail - libintl.so: cannot open shared object file: No such file or directory?
What does the message "ORA-12154: TNS:could not resolve the connect identifier specified" mean?
What are the common ORA errors encountered in configuring the SQL-Toolkit plug-in?
How to achieve E-mail alerting when an SQL toolkit returns 0 rows

See more

Self help

How to query SQL Server Agent Jobs?

November 01, 2019 16:33
Updated

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

SQLServer_Agent_Jobs-Sampler.xml
20 KB Download

Comments

0 comments

Please sign in to leave a comment.