to check whether specified database is working...

rajiivnb · Post by **rajiivnb** » Fri Mar 18, 2005 1:18 am

Hi all,

how do we verify that we are able to connect to all the databases that are setup in particular job, means in the source and the target odbc stages.

thnx in advance.

chulett · Post by **chulett** » Fri Mar 18, 2005 1:34 am

Do you mean automatically, perhaps as part of a job sequence? Or is this a general question?

In general, you can Validate a job rather than Run it to see if it can connect to all of the various source and target stages in the job.

rajiivnb · Post by **rajiivnb** » Fri Mar 18, 2005 1:46 am

Hi chullet,

its not actually a general question. see if i give dsn, username and password. instead of seeing the View data from a database stage.. is there any other option, just i want to verify the give dsn and the username password is working properly for the database stages...

thnx in advance

rajiivnb · Post by **rajiivnb** » Fri Mar 18, 2005 2:03 am

thnx chulett its working fine.

ArndW · Post by **ArndW** » Fri Mar 18, 2005 2:06 am

Rajiv,

Craig was talking in general as well as about your case in particular; you can do a VALIDATE run to see if your database connectivity and other job attributes are runnable or you can do a view data. Other ways of checking your DSN,UserId & Password are more convoluted.

If you wish to do this from a sequence it is quite easy, call up a dummy job that connects to the the database and use the return code to see if your Db is available.

DSXchange