datbase connection status..........

ketanshah123 · Post by **ketanshah123** » Thu Apr 06, 2006 6:26 am

hi
how to create a job just to check whether the connection with datbase is established or failed.........?
is there any routine or macro available if yes hoew to use it.........?

ArndW · Post by **ArndW** » Thu Apr 06, 2006 6:28 am

How about a simple job to read one record from a table (you could do something like a select from dual in Oracle) and writing that to /dev/null. If the job fails then you don't have a database connection.

chulett · Post by **chulett** » Thu Apr 06, 2006 6:46 am

You could also 'Validate only' a similar job from a Sequencer.

kduke · Post by **kduke** » Thu Apr 06, 2006 7:55 am

Craig, shame on you. I am going to tell Ray you used sequencer.

chulett · Post by **chulett** » Thu Apr 06, 2006 7:56 am

Oh nos, Mr Kim, please don't tell on me!

DSguru2B · Post by **DSguru2B** » Thu Apr 06, 2006 9:01 am

You can even select 1 from dual, and if you get a value 1, then your connection is present. The job will fail if there is not output from the select.

kcbland · Post by **kcbland** » Thu Apr 06, 2006 9:12 am

ODBC or OCI? If the command line for the database is available, consider a system command call to run a silly SQL statement and just check if it works. SELECT SYSDATE FROM DUAL is sufficient for Oracle using sqlplus. ISQL/OSQL are options for SQL-Server and SYBASE, dbaccess for Informix, and the DB2/UDB command line name escapes me right now.