How to solve common issues of database client installation in SQL-Toolkit plugin
How to solve Oracle connection issues in SQL-Toolkit plugin
How to fix the missing libmysqlclient_r.so file issue
What does the error "Fail - MySQL server has gone away(2006)" mean in the SQL-Toolkit plugin?
What are the common ORA errors encountered in configuring the SQL-Toolkit plug-in?
How to solve error "ORA-00911: Invalid character (911)" in SQL-Toolkit plugin
How to solve error "ORA-12154: TNS:could not resolve the connect identifier specified" in SQL-Toolkit plugin
How to solve error "Fail - ORA-12545: Connect failed because target host or object does not exist" in SQL-Toolkit plugin
How to resolve error: Fail - libintl.so: cannot open shared object file: No such file or directory?
How to solve error "Fail - ct_connect(): user api layer: external error: The connection failed because of invalid or missing external configuration data." in SQL-Toolkit plugin

See more

Self help

How to query SQL Server Agent Jobs?

September 19, 2020 04:10
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.