Splunk Search

dbConnect-Schedule

SplunkDash
Motivator

Hi,

Using dBConnect in SPLUNK, how I would setup to schedule my SQL query to run a particular time in a day or week. Any help will be highly appreciated. Thank you!

Labels (1)
Tags (1)
0 Karma

venkatasri
SplunkTrust
SplunkTrust

Hi @SplunkDash 

To ingest data from DB Splunk recommends db-connect add-on UI to test DB connectivity and create db inputs which actually executes given query at defined frequency. Follow this link - Create and manage database inputs - Splunk Documentation to schedule a inputs using cron expression.

You can query the DB table/other objects using dbx-query, that can be scheduled (cron, other ways) as savedsearch this will not ingest data there are other use cases that cater to this approach. Refer - https://docs.splunk.com/Documentation/DBX/3.5.1/DeployDBX/Commands

 

---

An upvote would be appreciated and Accept solution if this reply helps!

 

Get Updates on the Splunk Community!

Use ‘em or lose ‘em | Splunk training units do expire

Whether it’s hummus, a ham sandwich, or a human, almost everything in this world has an expiration date. And, ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Unlock New Opportunities with Splunk Education: Explore Our Latest Courses!

At Splunk Education, we’re dedicated to providing top-tier learning experiences that cater to every skill ...