It is currently 24 Jul 2017 5:00


Post new topic  Reply to topic  [ 4 posts ] 
Author Message
PostPosted: 18 Sep 2009 8:57 
Offline
Nouveau
Nouveau
User avatar

Joined: 03 Aug 2009 8:00
Posts: 3
Location: India
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 ?


Top
   
 Post subject:
PostPosted: 21 Sep 2009 5:05 
Offline
Nouveau
Nouveau
User avatar

Joined: 10 Jan 2007 9:00
Posts: 181
Location: Zagreb, Croatia
Well, you can use CONTROL-M FIlewatcher module for achieving this.
Look at BMC site, documentation.


Top
   
 Post subject:
PostPosted: 22 Sep 2009 1:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jul 2006 8:00
Posts: 134
Location: Switzerland
I have just uploaded "Control-M File Watcher Utility.doc" - a quick guide to FW. Note that it was written at the time of 6.0.1 and there are some new options with more recent releases. However the guide will get you started and will be enough for what you describe.


Top
   
 Post subject:
PostPosted: 18 Jan 2010 2:59 
Offline
Nouveau
Nouveau
User avatar

Joined: 12 Jan 2010 9:00
Posts: 3
Hi all,
I am using sql 2005 .
It works nicely, but I am unable to create local server for SQL authentication.
Has anyone faced this problem before?
Thanks in advance

_________________
buy r4i kaart


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 4 posts ] 

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved