SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Scheduling Jobs on Remote Servers

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Scheduling Jobs on Remote Servers
Author Message
Rob Thompson



Joined: 27 Jan 2000
Posts: 3

Post Scheduling Jobs on Remote Servers Reply with quote

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?


Thu Jan 27, 2000 11:02 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Re: Scheduling Jobs on Remote Servers Reply with quote

You are missing valid database profile on the agent computer (in your case NT server). The profile must be defined where the actual job take place. To create a profile, exit agent, start 24x7 in a normal mode. Create new profile, test it and exit scheduler, then restart the agent.

: 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?

Thu Jan 27, 2000 11:23 am View user's profile Send private message
Rob Thompson



Joined: 27 Jan 2000
Posts: 3

Post Re: Scheduling Jobs on Remote Servers Reply with quote

: You are missing valid database profile on the agent computer (in your case NT
: server). The profile must be defined where the actual job take place. To
: create a profile, exit agent, start 24x7 in a normal mode. Create new
: profile, test it and exit scheduler, then restart the agent.

I stopped the agent, brought up 24x7 in normal mode, created a database profile called tateller_branch, tested the connection, saved the profile, exited the scheduler and restarted the agent and still got the same results. Any other ideas on what may be wrong?

Thu Jan 27, 2000 3:06 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Re: Scheduling Jobs on Remote Servers Reply with quote

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?

Thu Jan 27, 2000 3:25 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Re: Scheduling Jobs on Remote Servers Reply with quote

>>> 2 more corrections:
Change line
DatabaseExport "user_table", "c:\table_list.lst", rowcount
to
DatabaseExport "user_tables", "c:\\table_list.lst", rowcount

: 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

: 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.

Thu Jan 27, 2000 3:28 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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 vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.