Quote:
Can you explain your issue? It is really not clear to me... ( I understand ""seems to work... but not always ..." )
I am trying achive the following:
In the database one request will be running. That request runs for long time.
So instead of keep on checking it manually whether request is completed or not, I want shell script to check the request status (say for example every 1 minute) and if the request is completed then shell script should email me the request status ( that is it should email me the file generated by query, in this case it should email me file .txt file mentioned in the shell script).
The issues are :
1) its unnecessary keep on printing output on Standard output following text until condition is met.
==========
no rows selected
1
==========
2) Even if the request is completed and its phase_code is "C" (C- for completion).
my mentioned shell script keep on print about give ( no rows select and 1) to screen.
So the logic I used in the shell script me may be incorrect and I have to use FOR loop instead of this .... You your help.
Thanks,
Raj