Query using JDBC Probe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2023 02:27 AM
Hello,
execute the following
1) use JDBC prob to query DB
2) based on response update records on same DB using JDBC prob
At the moment we have failed on step one. We have followed this article to create a record to query DB in ECC_queue https://john-james-andersen.com/blog/service-now/using-the-servicenow-jdbcprobe.html
Everything looks normal until we get to the below - this record never moves from "Ready" and we never get the "JDBCProbeResult" record
What is also odd is we do not see any errors in the system logs or on the MID itself?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2023 10:06 PM
If I understood Correctly
Step 1 - is to query the outside DB and get results
So ECC queue value should be - Output first so that Mid Server Processes it.
Also use a small code snippet to just test the connectivity first.
Regards
RP