Problem: Run schedular to copy from one table to other


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Problem: Run schedular to copy from one table to other
# 1  
Old 06-02-2008
Problem: Run schedular to copy from one table to other

Check if records of table B are 1 month old. if yes then Truncate table B_SNAPSHOT and then copy data from B to SNAPSHOT_B table otherwise no need to copy.
Run a schedular after every 15 minutes.


The tables B and SNAPSHOT_B has the below structure(same for both):

PROCESS_NAME
MQ_NAME
LAST_UPD_TMS

How I can do that using Unix and Oracle 9i.Need help with example script.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies

2. High Performance Computing

Job Schedular for Suse Enterprise SLES 11 SP2

We have a server with 160 hyper-threaded cpu's threads and 2Tb of RAM. I need to implement command line job queue and parallel thread usage for multiple user environment kindly suggest necessary tools to be installed. I have understanding that sun grid engine like applications are available for... (0 Replies)
Discussion started by: vaibhavvsk
0 Replies

3. Shell Programming and Scripting

Copy and run that script in Remote server

Hi All, I need script to perform below task. 1. I have a script in one server and need to copy this script to remote server 2. login in to remote server 3. run the script which i copied to this server. #!/bin/bash read a scp /tmp/script.sh user@hostname:/tmp ssh user@$a ./scirpt.sh ... (2 Replies)
Discussion started by: bapu1981
2 Replies

4. UNIX for Dummies Questions & Answers

Unix Shell Script on Tidal schedular for ETL

Hello I am very new to Unix scripting, I am using informatica etl,which is schedule by tidal enterprise. I have a scenario where assume that Tidal only knows how to run jobs at a given time and does not know how to retry. So i want to know weather can i write a shell script such that... (1 Reply)
Discussion started by: bluestarmoon
1 Replies

5. UNIX for Dummies Questions & Answers

What is in-core copy and disk-copy of i-node table?

I have found a question from the exercises of my study mat. The question is "Why are there a in-core copy and a disk-copy of i-node block and super block?" If any one know the proper answer then please send me..... (1 Reply)
Discussion started by: dearanik
1 Replies

6. Red Hat

mounting a copy of a disk without patition table

Ok. I screwed up. Using dd, I made a bit-for-bit copy of disk /dev/hda, which contains 3 partitions. dd if=/dev/hda of=olddrive.iso bs=2048k However, I neglected to make a copy of the partition table. I'd like to mount partition 3, /dev/hda3, which is an xfs filesystem, but obviously I don't... (2 Replies)
Discussion started by: dangral
2 Replies

7. UNIX for Advanced & Expert Users

Schedular

Hi, I was looking for a schedular(a simple script would do or a tool) that would invoke jobs on few conditions: 1. Every day 2. Every working day(Considering customized holiday list, from a file or table) 3. Weekly 4. being able to define variable dependency. like on every day run,... (1 Reply)
Discussion started by: ahmedwaseem2000
1 Replies

8. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal. (1 Reply)
Discussion started by: royal9482
1 Replies

9. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

hi i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database i have a main database - db1 and i have a table in that database - userips i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies

10. Shell Programming and Scripting

Creating a Schedular to Run the Jobs.

Hi, I have to create a sheduler to run the shell scripts one by one(dependency). Suppose i have 10 scripts. For all the 10 scripts i have a database table containing these scripts_names and status. Executing the first script.if the first status script is only 'success' then go to next... (4 Replies)
Discussion started by: laknar
4 Replies
Login or Register to Ask a Question
XmStringTableToXmString(library call)									     XmStringTableToXmString(library call)

NAME
XmStringTableToXmString -- A convenience function that converts a compound string table to a single compound string SYNOPSIS
#include <Xm/Xm.h> XmString XmStringTableToXmString( XmStringTable table, Cardinal count, XmString break_component); DESCRIPTION
XmStringTableToXmString takes as input table of compound strings and a specified string component (such as a tab) and returns a single com- pound string consisting of each of the elements of table concatenated together with a single copy of break_component inserted between each element. table Specifies an XmStringTable containing the compound strings to be converted. count Specifies the number of compound strings in table. break_component Specifies the XmStringComponent that will be inserted in the result to separate the individual elements of table. The most useful types will be XmSTRING_COMPONENT_SEPARATOR and XmSTRING_COMPONENT_TAB. Refer to the XmStringComponentType(3) reference page for a complete list of possible component types. Note, however, that the XmSTRING_COMPONENT_UNKNOWN component is not a possible type. RETURN
Returns a new XmString. The function will allocate space to hold the returned compound string. When the application no longer needs the returned compound string, the application should call XmStringFree. RELATED
XmString(3), XmStringComponentType(3), and XmStringFree(3). XmStringTableToXmString(library call)