How to write cron job for calling sql function database is postgres Post: 302504586

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how will i connect postgres database from unix shell script

I have got the solution so just closing this issue.

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

3. Shell Programming and Scripting

Calling SQL script from ksh job and send mail on some error.

Hi, I am trying to call sql script from ksh job with parameters.The parameters passed from ksh job will be used in SELECT query in sql file to SPOOL the data in extract file.My questions are: 1) How to call a sql script from ksh job with parameters? 2) How to use the parameter in sql file to...

4. Homework & Coursework Questions

Shell script calling Perl function, sort and find data, write to new files

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and...

5. Shell Programming and Scripting

Calling Pl/sql function in shell script to modify csv

I need to 1.Open a csv 2.Process the csv i.e. Modify 2 column in the csv. To modify the column the value needs to be passed to a pl/sql function and the return value should be updated For eg: If column 2 E,then E will be passed in database function which will return Employee. 3. Write a...

6. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the...

7. Shell Programming and Scripting

Taking information from a postgres sql query and putting it into a shell script array

I have a postgres sql statement that is the following: select age from students; which gives me the entries: Age --- 10 15 13 12 9 14 10 which is about 7 rows of data. Now what I would like to do with this is use a shell script to create an array age. As a results...

8. Shell Programming and Scripting

Using shell scripting for making queries on postgres sql

I have a situation where I have a list of airplanes that make a series of flights. Therefore I am looking up the different flights that each airplane makes based on a postgres sql query: select flightid from plane where airplane='DELTAx' As a result I get a series of flight numbers...

9. Shell Programming and Scripting

Need help to write a function in shell scripting to execute sql files

Hi, I am new to shell scripting and i need to write a automation script to execute sql files. I need to check the table if it is there in system tables and need to write a function to call the .sql files. For ex. I have a.sql,b.sql,c.sql files, where the sql file contains DELETE and INSERT...

10. UNIX for Beginners Questions & Answers

Add TimeStamp to cron job and write file name sent

Hello, I have written a cron job to automate the sftp of files using key authentication. I wanted to add a timeStamp and name of file sent to a log file and append each these details to the same file each time files are sent and if possible include whether the files were sent successfully or not....

LEARN ABOUT DEBIAN

dwww-refresh-cache

DWWW-REFRESH-CACHE(8)						      Debian						     DWWW-REFRESH-CACHE(8)

NAME

       dwww-refresh-cache - rebuilds dwww cache directory

SYNOPSIS

       dwww-refresh-cache

DESCRIPTION

       dwww-refresh-cache  is  a  simple  shell  script,  which  deletes  outdated  cache  files and rebuilds contents of the dwww cache directory
       /var/cache/dwww.  In default installation, the script is called from /etc/cron.daily/dwww, so the cache is refreshed every day.

CONFIGURATION VARIABLES

       DWWW_KEEPDAYS
	      Specifies, how many days documents that have not been accessed should be kept in the cache.  Default is 10 days.

       DWWW_QUICKFIND_DB
	      Location	of  the  installed  packages  and  programs  cache  file,  generated  with  help   of	dwww-quickfind(8).    Default	is
	      /var/cache/dwww/quickfind.dat.

       DWWW_DOCBASE2PKG_DB
	      Location	of  the  cache	file,  which  maps installed doc-base files to packages names, used by the dwww-build-menu(8).	Default is
	      /var/cache/dwww/docbase2pkg.dat.

FILES

       /etc/dwww/dwww.conf
	      Configuration file for dwww(7).

       /var/cache/dwww
	      dwww cache directory.

       /etc/cron.daily/dwww.
	      dwww daily cron job

SEE ALSO

       dwww(7), dwww-build-menu(8), dwww-cache(8), dwww-find(8).

AUTHOR

       Robert Luberda.
       See dwww(7), for copyrights and stuff.

dwww 1.11.1							February 15th, 2009					     DWWW-REFRESH-CACHE(8)