How do I make a query that runs once and then disables in Splunk DB Connect?

[rakesh44]

I have to run DB connect query only once.

What execution frequency do I have to set in Splunk DB Connect, if want I to run a query this coming Monday, which is 17th Dec 2018, and it should run only once?

Once it has ran, how do I disable the query from Splunk DB connect?

[kmaron · Accepted solution]

Build your input for the query and set your cron schedule to something like 1 0 17 12 * (this would be 1am on December 17th).
After your query runs you can either use the App GUI to disable it by clicking the disable switch or in the inputs.conf file you can set disable=1