What I have:

I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)

note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates output file by that integer I passed (output1.out, output2.out .... etc....)

I simply run this command now: sh input.sh 88 |mysql -h XXXX -u XXXX -p XXXX ---> this writes back the output(output1.out) file to a location.

What I require:

I want to write a wrapper script and schedule with a cron job --

to run this script daily with multiple unique_id's at once and writes out the output files with respective unique_id numbers ( output1.out, output2.out etc..) and send the resulting output file (output1.out) as an attachment to an email distribution list..

The format of the output file should: more manageable, for example, the email recipients(users) can change the format so it can be read/edited in excel, add a column for action.

o/p file to send in email, for example:

output1.out --- email1.abc.com

output2.out --- email2.xyz.com etc....

please let me know how does this works - let me know in detail steps (kind of new to crontab)

Thanks in Advance