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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...