unix scheduling tasks
hi guys
I have the following scenario
I have two databases
Database1 has table1
Database2 has table2
I am working with a java application which uses Table2.
One of my requirment is
I have to pull some data from table1 and insert it into table2 and we have to do this twice every week (Monday 2.00 AM and Friday 2.00 AM)
We are using ubuntu version of unix.
our team does not have much experience with unix since we primarily use windows.
Can anyone guide me through the steps i need to know do accomplish our task?
Do i use cron job , not sure?
Any help will be appreciated.
thanks in advance
I have the following scenario
I have two databases
Database1 has table1
Database2 has table2
I am working with a java application which uses Table2.
One of my requirment is
I have to pull some data from table1 and insert it into table2 and we have to do this twice every week (Monday 2.00 AM and Friday 2.00 AM)
We are using ubuntu version of unix.
our team does not have much experience with unix since we primarily use windows.
Can anyone guide me through the steps i need to know do accomplish our task?
Do i use cron job , not sure?
Any help will be appreciated.
thanks in advance
ASKER
>>Will you give some more details?
sure
We are using MS-SQL server2005 database.
Data from table one (of Database1) needs to be fetched and inserted into table2 (of Database2
We are planning to use MSSQL stored procedure to do this.
create package.storeProc
SELECT * from TRADING_PROFILE
INSERT into TRAD_PROFILE
...
...}
The above store proc (or SQL) will be called from a java program (we have a spring j2ee set up)
The task in hand is scheduling the FETCH from table 1 and INSERT into table 2 every Monday 2.00 AM and Friday 2.00 AM.
Hope that helps,
thanks.
sure
We are using MS-SQL server2005 database.
Data from table one (of Database1) needs to be fetched and inserted into table2 (of Database2
We are planning to use MSSQL stored procedure to do this.
create package.storeProc
SELECT * from TRADING_PROFILE
INSERT into TRAD_PROFILE
...
...}
The above store proc (or SQL) will be called from a java program (we have a spring j2ee set up)
The task in hand is scheduling the FETCH from table 1 and INSERT into table 2 every Monday 2.00 AM and Friday 2.00 AM.
Hope that helps,
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Will you give some more details? what database engine are you using? Are you trying to pull some data from the table1 and insert into table2 ? Or are you looking into import entire table to table2?
in fact there are different methods to implement them.
Cheers,
K.