| Newsgroups |
gmane.comp.db.oracle.toad.free |
| Message-ID |
<[email protected]> |
Hi;
On a scale of 1 to 5, with 5 being the most
knowledgeable, I am a 1.5 as a TOAD user. I work for a small shop as a Report
Writer and create queries and views for use in Crystal Reports, mostly. Oh…and we do not have a DB Programmer on
staff; the db we work with is owned by our Software vendor, who tend to be unhelpful with this type of thing. We have two versions of TOAD, 10.6.13 and 11.0.0.116.
Recently, the contracted with a third-party vendor
to do some work for us and we need to provide them with a recurring file of
customers. The text file must be
formatted in as pipe delimeted and the file name must use this convention: THC_MEMBERS_YYYY-MM-DD-HH-MM-SS.txt, where
datetimestamp changes on every run and is in the specified format in the file
name (THC_MEMBERS_2013-01-03-14-51-47.txt).
The query has already been created and the data
exported manually and all is fine, however, I want to automate and schedule
this function. In order to do so, I need
step-by-step instructions, including how to save the file with the above
specified naming convention. It probably needs a variable, but I don’t know how
to do that. I started looking at the Automation Designer, but quickly lost my
way.
Is there anybody who can point me to an easy to
use/understand set of documents that will help me figure this out, please???
Thank you in advance,
Sandi