I want to schedule a job which runs the attached query on database every day and also email of the output should be delivered to email address
hey @vevo99
First you need to configure email server settings in splunk
https://www.splunk.com/blog/2014/06/27/splunk-alerts-using-gmail-twitter-phone-calls-and-much-more.h...
to schedule a JOB in splunk i.e. alerts
https://answers.splunk.com/answers/345944/how-to-schedule-a-job-in-splunk.html
to schedule reports
http://docs.splunk.com/Documentation/Splunk/7.0.1/Report/Schedulereports
Also look at
https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Search/Schedulingsearches
Let me know if this help you!