Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email.
Here's what I already have.
I'm calling the script using
Quote:
nohup ksh counts.sh user password db
The script is already sending an email "Counts on $DB_DBASE is" without the actual result of the query.
I'm a total stranger in Shell scripting and just basing my work on the existing scripts in our project.
Hi
From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp.
can someone help me to do that .
Thanks... (2 Replies)
Hi,
I want to spool the output from a .sql file to a .txt file through shell script.
the contents of .sql are:
spool /arboru02/scripts/customer_profile_def.txt
select profile_id ||','|| account_no
from customer_profile_def;
spool off
exit
and shell scrip is like:
#!/bin/sh... (9 Replies)
Hi
I have done a search for this but couldn't find much on it.
I am creating a tar file with the command below
tar cvf /export/home/user/backup/*Will this is being created I have a job spooling to 5 texts files in the following directory /export/home/user/backup/STATS/
The tar files... (1 Reply)
Hi ,
Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this..
O/p is coming as header till batch id ,im not able to see date_stored,type,type1..
Please any one can give me some suggestion
... (1 Reply)
Hi everyone and nice to meet you :)
I'm having some issues with a script I'm writing.
It's probably most chaotic, I'm no ksh guru, but the idea is to extract an ID with that query, spool it into a file, and read that file making the ID a variable. This has to be done for every row extracted by... (10 Replies)
Hello, I need to replace newline with tab at certain lines of the file (every four lines is a record).
infile.fq:
@GAIIX-300
ATAGTCAAAT
+
_SZS^\\\cd
@GAIIX-300
CATACGACAT
+
hhghfdffhh
@GAIIX-300
GACGACGTAT
+
gggfcfoutfile:
@GAIIX-300 ATAGTCAAAT + _SZS^\\\cd
@GAIIX-300 ... (6 Replies)
Hi Guys,
Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below:
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327... (8 Replies)
Hello all,
I am trying to spool a SQL query output file from back-end to desktop in a certain path but it didn't work,the query writes the output in a file in the same directory at the back-end.
note : i use the same query in sql developper and file was created in the desired path fine
code... (1 Reply)
Discussion started by: bmaksoud
1 Replies
LEARN ABOUT SUSE
pollrcvd
POLLRCVD(8C)POLLRCVD(8C)NAME
pollrcvd - HylaFAX script for delivering facsimile received by polling
SYNOPSIS
/var/spool/fax/bin/pollrcvd mailaddr faxfile devid commid error-msg
DESCRIPTION
bin/pollrcvd is the command script invoked by the HylaFAX server whenever a facsimile is received as a result of a polling operation. The
default script uses electronic mail to deliver the facsimile to the user that submitted the poll request, and can be controlled by editing
the etc/PollDispatch shell script in the spooling area that is sourced by pollrcvd when it runs. The arguments are:
mailaddr the electronic mail address of the user that submitted the poll request.
faxfile the pathname of the received TIFF file relative to the root of the spooling hierarchy.
commid The communication identifier associated with the call (used to include a transcript when an error occurs).
devid the modem device on which the document was received.
error-msg an error message that is non-null if an error was encountered during the receive operation.
NOTES
The default script delivers facsimile as PostScript wrapped in MIME.
FILES
/var/spool/fax spooling area
/usr/sbin/faxinfo for printing information about the facsimile
/usr/bin/fax2ps for converting TIFF to PostScript
/usr/sbin/sendmail for delivering mail
SEE ALSO faxq(8C), hylafax-server(5F), recvq(5F)
May 12, 1996 POLLRCVD(8C)