Using Splunk-DB database outputs I am sending results to database. How do we know that if particular database update has failed. Can we create alerts
If you are using DBConnect, it has extensive logging options, which can be configured in Settings. Before contacting Splunk support, you might want to enable debug logging, in case you need to provide Splunk support with DB Connect debug logs. Splunk DB Connect activity is logged to files in $SPLUNK_HOME/var/log/splunk and automatically indexed to _internal. The relevant log files for DB Connect are
splunk_app_db_connect_server.log
splunk_app_db_connect_job_metrics.log
splunk_app_db_connect_dbx.log
splunk_app_db_connect_audit_server.log
To view DB Connect logging activity, use a search command such as the following:
index=_internal sourcetype=dbx
Full details are here:
http://docs.splunk.com/Documentation/DBX/2.0.5/DeployDBX/Troubleshooting