I need to write a shell script which does the following:
script shld be in such a way that I just need to pass a parameter and it shld generate the report by running a sql script and store it in a directory and email this report in every 30mins .this shell script should pass a parameter (by calling a function) into a sql script and generate a report and I want the name of the report in a specific format.
can someone please pass on the script if anyone has it or let me know how to do this?
any help is appreciated!!