Instead of a batch file you can create a JAL script or VBScript job in 24x7 that will check for the "table accessibility" and then run your existing batch if that table is "accessible." Of course the implementation of this check for accessibility depends on what you mean by that word. If you mean existence of a table you would need to check it in the system catalog (ALL_TABLES, sysobjects, or whatever your db offers) or do a test SELECT from it. If you mean table locking your will need to check system tables containing locking data; if you mean db accessibility you may try a test connect, if you mean existence of certain data you will need to search for it; this list is really endless. If you want to get a more specific and helpful answer please provide more specific details about your environment and avoid using vague definitions. : I want to run a query from a batch file that that tells me a table is
: accessible.
: Then if the result of that query is true, launch another batch file. : I need to sense if a table in a DB is accessible BEFORE I run a batch file
: that truncates a different table in preparation for inserting data. : Thank You in Advance.
: jtontz@co.riverside.ca.us
|
