Shell Programming and Scripting

Hi ,

Daily I sneding report to client about the status of State 2 jobs in Control M .

I would like to schedule it via cron . I am using teh following command :

sudo su - <control M server Name>
then reach to the control M server

then run

#isql
<It ask for the password >

Password :

When I give the password I execute the following command

1> select JOBNAME from CMR_AJF where STATE='2'
2> go

It gives the following out put

JOBNAME
----------------------------------------------------------------
AI_BRS_BNP_CompanyOption_PDF
AI_BRS_BNP_DiscountSecurityBlock_PDF
AI_BRS_BNP_EquityListedBlock_PDF
AI_BRS_BNP_FixedInterest_PDF
AI_UNITPRICE_Transfer
(5 rows affected)


Inormally paste this in my mail box and send an email to the client.

How I will write a script by which I can send the the output in one file and then outomatcially send mail via mailx.

Thanks in Advance

Two options:

1. Add a "post process" condition and action on the job in Control-M , which will fire the necessary alert mail.
2. If you want to configure using script, try something like below:

Code:

sqlplus username/password@db_connectionstring <<EOF
select ....;
exit;
EOF