DSXchange

Posted: **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

Posted: **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.

Posted: **Thu Oct 29, 2009 4:35 am**

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

Thanks,
Ravi

Posted: **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.

Posted: **Fri Oct 30, 2009 1:06 am**

Thanks

DSXchange

Raise a error if database(Oracle) connectivity is failed

Raise a error if database(Oracle) connectivity is failed

Raise a error if database(Oracle) connectivity is failed

Raise a error if database(Oracle) connectivity is failed