IronClad26
Programmer
Hello everyone,
I am new to the unix scripting arena, so I just had a question on the level of diffculty (and reality check) on something I want to code.
My idea is to have a cron job call a korn shell script that will initially call a stored procedure on an Oracle 9i database. This stroed proc will query the database and create a file of email addresses (1 per line). Once the file is created, the korn shell script would then open the file and loop through the email addresses in the file. For each email address it would send a command to a postfix email engine, telling it to send an email to the email address with a specified subject and email body.
Does this approach seem logical? How difficult is it for a beginner? Can you think of a cleaner/better solution?
Thanks,
IronClad26
I am new to the unix scripting arena, so I just had a question on the level of diffculty (and reality check) on something I want to code.
My idea is to have a cron job call a korn shell script that will initially call a stored procedure on an Oracle 9i database. This stroed proc will query the database and create a file of email addresses (1 per line). Once the file is created, the korn shell script would then open the file and loop through the email addresses in the file. For each email address it would send a command to a postfix email engine, telling it to send an email to the email address with a specified subject and email body.
Does this approach seem logical? How difficult is it for a beginner? Can you think of a cleaner/better solution?
Thanks,
IronClad26