First off, please excuse my ignorance on this matter, I'm a VB/Pascal hardcode programmer and I have been "drafted" to find a solution (shouldn't have missed that meeting...LOL).
Anyway, on my server, there is a ksh program (I'm assuming that this is a compiled script). This program populates some data tables. This program is set to run every evening. My problem is that I need to periodicaly run this executable on command.
Here is my question(s) :
Is there a way that I can run this program (I'm assuming that it is an executable file)? If so, do I have to use an interface/console program, or can I use a commandline program to call this program and run it (kind of like running an exe from a dos prompt)?
Another question (blushing on this one) :
Does SQL have a command interface where I can access the program/script and execute it rom there?
Once again, I apologize for my ignorance on this whole subject.
Your assistance is appreciated,
PS. if an answer to my above questions would require too long an explanation, if you could direct me to a good resource in the net to learn more about this, I would appreciate it.