Raise a error if database(Oracle) connectivity is failed

bachi · Post by **bachi** » Wed Oct 28, 2009 8:06 am

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

chulett · Post by **chulett** » Wed Oct 28, 2009 8:25 am

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.

bachi · Post by **bachi** » Thu Oct 29, 2009 4:35 am

Can you please tell me one way of doing other than script?

Thanks,
Ravi

ArndW · Post by **ArndW** » Thu Oct 29, 2009 5:48 am

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.

bachi · Post by **bachi** » Fri Oct 30, 2009 1:06 am

Thanks