Hi All,
I have requirement : before I run my job I have to check database connectivty and if it is failed I have to try after 10 then also failed the error message should be send in sequence
please help on this,
I sure that we need Unix script for this can you help to write that script
thanks in advance
Ravi
Raise a error if database(Oracle) connectivity is failed
Moderators: chulett, rschirm, roy
There are many ways to do this, including a small 'do nothing' job that connects to that database that you Validate rather than run. For the scripted approach, involve your DBA.
Last edited by chulett on Thu Oct 29, 2009 7:38 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Raise a error if database(Oracle) connectivity is failed
Can you please tell me one way of doing other than script?
Thanks,
Ravi
Thanks,
Ravi
he did tell you another way. Write a job that connects to the database (a dummy read, for example) and then it is validated instead of run; the return code from the validate run can be used in a sequence job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>