Am not a SQL person, but am tryin to learn and write scripts
This is my scenario:
A bunch of files get FTPd into "server A" at a certain time. These file names are alpha numeric and to understand the names, an application is used. This application links to a SQL DB that helps understand the file name i am looking for. i.e. I know a file name 123. But that is actually stored in a different name in the folder. The sql db helps relate the filename and the actual file..
Now, am trying to automate this using sql queries in control-m.
What i am trying to accomplish:
the control-m job uses the sql queries, finds if the files are there are not and gives me a shout message.
The problem i think here is that the files come in random. A file may come today, may not tomorrow.regardless, i have to check for the files
My plan:
write a script with the sql queries ( donno how- may be vb.. the sql server is on a windows box) for the files (40 files per script, per control-m job)
hope that the sysout would give me a return code if the file is present or not..
shout with ended ok and email of the sysout to a mail id (not sure if this can happen)
is this possible ? what are the problems i might run into ?