user13340968 wrote:what kind of sound does a table make?
Is it possible for Windows Task Scheduler to listen for a table on Oracle (Unix box), and if it exists, run the task it is assigned to.
Is it possible to install Oracle agent on the Windows box, listen for a table on the Oracle DB (Unix Box) and have the Oracle agent on the windows box run the windows task scheduler event?
user13340968 wrote:SELECT COUNT(*) FROM MYSTERY_TABLE;
thats a good question...hahaha....just want it to listen if the table exists or not.
thats a good question...hahaha....just want it to listen if the table exists or not.Are you looking for below thread ?
user13340968 wrote:This sounds eerily similar to your other two threads:
I understand how to write the SQL query, what I'm having trouble with is how to implement that in a Windows Task Scheduler so when the table does exist, the task scheduler kicks off. Not sure if its easy to do it in that or use Oracle Agent on the remote server(not even sure if that can do this)? I'm new to the oracle environment as well but am extremely familiar with SQL.
Basically, during the ETL, an analysis runs and if a business critical event occurs, it would create a table (which the report server would use). The Task Scheduler or Oracle agent would run each minute to listen to that table and if it exists, run a BAT file on the report server which would email out the report.
The big issue that I'm trying to resolve is essentially how to make the report box (windows) listen to the oracle box (Unix). If the report server detects that table on the Oracle box, it will execute a BAT file (located on the report server) on the report server.
user13340968 wrote:This is not correct, it very easy for Oracle to run a file on another machine through the Scheduler. Run the file as a remote job:
yes, they are...but it seems extremely difficult for oracle to execute the BAT file on another machine....
user13340968 wrote:You are going about this in just about the worst way possible. Instead of fixating on some ill-advised technical solution, why not describe your business problem and ask for the best possible approach?
yes, they are...but it seems extremely difficult for oracle to execute the BAT file on another machine....thinking if I can write a script in windows task scheduler which would run each minute to see if the table is there, if it is, then it can run the process....don't know if this would be easier then trying to get Oracle on Unix to run a BAT file on a windows machine.
user13340968 wrote:Wrong download. The docs do say that you need the client CD:
ok..this sounds pretty dumb but I cna't seem to install the Oracle Scheduler...
I downloaded this: