05-30-2013
Have a read of the manual pages for the
cron scheduler to get this done each day.
Let us know how you get on.
Robin
Liverpool/Blackburn
UK
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to execute my script as soon as one log file arrives.
This log file is named as logyymmdd. I need to add trigger to my script based on this logfile.
Please guide. (1 Reply)
Discussion started by: nishigupta
1 Replies
2. Shell Programming and Scripting
I'm getting to grips with this concept of the umask.
What I thought was, setting umask uga+rwx would result in creating files with all permissions for everyone. Seems not to be the case though. Read and write bits get set, but not the execute bit.
Is there some gap in my understanding, or is... (2 Replies)
Discussion started by: tphyahoo
2 Replies
3. UNIX for Dummies Questions & Answers
I have a folder with many subdirectories and i need to set the modified date to today for everything in it. Please help, thanks!
I tried something i found online, find . -print0 | xargs -r0 touch
but I got the error: xargs: illegal option -- r (5 Replies)
Discussion started by: glev2005
5 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have to write a script to compare the sum of the amount fields in a source file and the amount field in another file.
details are:
based on the name of the source file (say SALES as an example), a file already available in a path will be grabbed (say SALES_ParmFile) and this file... (4 Replies)
Discussion started by: vijaylak
4 Replies
5. Shell Programming and Scripting
needed touch command to create a file in the following format
touch a_yyyymmdd_hhmmss (1 Reply)
Discussion started by: hemanthsaikumar
1 Replies
6. Shell Programming and Scripting
Hi,
I make a sftp connection successfully.My requirement is the script shall execute only after i find a trigger file(dailyreport.OK.psv) in the remote dir. If the trigger file is not present ,the script should exit else it should continue with the rest of the scripts statements. Below code is... (13 Replies)
Discussion started by: samrat dutta
13 Replies
7. UNIX for Dummies Questions & Answers
I have noticed that the following command works
touch subtext_geopdf_to_.x
However this one does not
touch subtext_/geopdf/_to_/.x
How can I create such a file without making it think I supplied a path? (2 Replies)
Discussion started by: kristinu
2 Replies
8. Shell Programming and Scripting
Hello Team,
Is there any Linux command / script available so that, I could create a simple 0 byte file in destination server by issuing the command from source server.
If yes, Could you please let me know the possible solutions.
in other words I just want to create a touch file in my home... (1 Reply)
Discussion started by: madhuraju
1 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I am creating a script in which we will check a folder. If any file placed inside the folder, script will move the file to another folder and Trigger etl process.
Now the issue is that the script should continously check the presence of file inside folder after every minute or hour. So how... (1 Reply)
Discussion started by: dgargd2524
1 Replies
LEARN ABOUT LINUX
alter_trigger
ALTER
TRIGGER(7) SQL Commands ALTER TRIGGER(7)
NAME
ALTER TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table RENAME TO newname
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name The name of an existing trigger to alter.
table The name of the table on which this trigger acts.
newname
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE [alter_table(7)], not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE [alter_table(7)]
SQL - Language Statements 2010-05-14 ALTER TRIGGER(7)