1) Sorry, I didn't get your question first time. "spool c:\table_list.lst select table_name from user_tables; " Here is the problem: SPOOL is not a valid SQL command (it is SQL*Plus extension and the SQL command). To save the list of table in file Dim rowcount, number DatabaseConnect "tateller_branch" DatabaseExport "user_table", "c:\table_list.lst", rowcount DatabaseDisconnect 2a) To run .CMD file you should run the following command cmd /b shutdown.cmd or simply do it directly without using shutdown.cmd d:\orant\bin\oradim80.exe -shutdown -sid TBRN -usrpwd branch -shuttype : srvc,inst -shutmode i Same thing is for startup. 2b) As for the Oracle services, make sure to specify correct service names. Note that different Oracle versions use different names. Do not use the example from on-line help as it is, check service names using the Control Panel Services applet. : I recently downloaded your product and am testing it out for some scenarios : for one of my companies clients. : 1) I have two machines setup in a test environment. An NT workstation : configured as a master scheduler and an NT server configured as a remote : agent. I have tested the communication between the two and the master : scheduler finds the remote agent fine (NT server). I have set up a : database profile for an Oracle 8.0.5 database running on the NT server and : have tested the connection and reviewed the trace file that was created : and the profile seems to be able to connect to the database. : 2) I have setup some sql jobs to be run from the master scheduler on the NT : server via its remote agent. The sql is setup to just get the table names : from : database and spool the output to a text file. e.g. : Thanks in advance : spool c:\table_list.lst : select table_name from user_tables; : there is no spooled text file on either the master scheduler machine or on : the remote agent machine. : 2) I have setup some command files to start and stop the database service. I : have tried placing the files on the remote agent and trying to schedule it : from there and have tried placing on the master scheduler machine and : tried running it from there. The files are set up to do the following: : shutdown.cmd : d:\orant\bin\oradim80.exe -shutdown -sid TBRN -usrpwd branch -shuttype : srvc,inst -shutmode i : startup.cmd : d:\orant\bin\oradim80.exe -startup -sid TBRN -usrpwd branch -starttype : srvc,inst -pfile d:\orant\database\tbrn_init.ora : both of these command files work when run on the NT Server via a DOS command : prompt. : starts the database service via a NT .cmd file : I have even tried using the JAL scripting language to try and shutdown and : startup the database service. : Am I missing something on the remote agent. I appears that nothing is running : on the NT server and all of the sql script return and exit code of -1. : Does the scheduler not support spooling to text files?
|