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
XtGetKeysymTable()														XtGetKeysymTable()

Name
  XtGetKeysymTable - return a pointer to the keycode-to-keysym mapping table of a  display.

Synopsis
  KeySym *XtGetKeysymTable(display, min_keycode_return,
  keysyms_per_keycode_return)
	   Display *display;
	   KeyCode *min_keycode_return;
	   int *keysyms_per_keycode_return;

Inputs
  display   Specifies the display whose table is required.

Outputs
  min_keycode_return
	    Returns the minimum keycode valid for the display.

  keysyms_per_keycode_return
	    Returns the number of keysyms stored for each keycode.

Returns
  The keycode-to-keysym table for display.

Availability
  Release 4 and later.

Description
  XtGetKeysymTable()  returns  a pointer to the Intrinsics' copy of the X server's keycode-to-keysym table, which must not be modified by the
  application.	This table is simply an array of KeySym.  The number of keysyms associated with each keycode is returned in  keysyms_per_key-
  code_return.	 The  first  keysyms  in  the table are for the keycode returned in min_keycode_return.  The keysyms for a keycode k begin at
  index:

     k - min_keycode_return) * keysyms_per_keycode_return

  Any entries in the table that have no keysyms associated with them contain the value NoSymbol.

Usage
  The Intrinsics maintains a table internally to map keycodes to keysyms for each open display.  The Translation Manager uses this table, and
  custom keycode-to-keysym translator procedures (see XtSetKeyTranslator()) and other clients may also need to use it.	Most applications and
  widgets will never need to use this function.

  You should not cache this keysym table but should call XtGetKeysymTable() each time the value is needed, because the table  may  change  at
  any time.

See Also
  XtConvertCase(1), XtKeysymToKeycodeList(1), XtRegisterCaseConverter(1), XtSetKeyTranslator(1), XtTranslateKeycode(1).

Xt - Keyboard Handling														XtGetKeysymTable()