Check Oracle Connection if available

dataservices job design
1

hi guys i want to make a CONDITIONAL that check connectivity from an oracle db.
if it can connect to that db then do stuff if not than do nothing.

any idea??

Thanks…

Denso (BOB member since 2010-07-22)

2

A script between a try-catch and in the script you call some arbitrary sql() function would be my idea.

Werner Daehn :de: (BOB member since 2004-12-17)

3

If the DB is Oracle then my script would be

SELECT SYSDATE() FROM DUAL;

ganeshxp :us: (BOB member since 2008-07-17)