Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Quarterly get count of license and store in file (http://www.go4expert.com/forums/quarterly-count-license-store-file-t21930/)

bongalegre 28Apr2010 10:55

Quarterly get count of license and store in file
 
Hi Guys,

I really hope you could help me I am just new in Oracle but my boss is forcing me to do scripting he said everything is available online. I tried to create but he said it was wrong maybe you can give me a helping hand.

This will be my crontab entry
#!/bin/sh
* * 1 1,4,7,10 * . .profile; /root/bin/SubLicenseCounter.sh QUARTERLY >>/trace/SubLicenseCount.log 2>&1

SubLicenseCounter.sh
sqlplus owner/owner
select count(*) from tb_subscription s, tb_counter cnt where s.tb_destinationaddress is not null and s.tb_ID = cnt.tb_ID and cnt.tb_SENDVALUE>0;

Please help. Thanks!

/bong


All times are GMT +5.5. The time now is 02:03.