10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
2. Shell Programming and Scripting
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies
3. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
4. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
5. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
6. Shell Programming and Scripting
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies
7. Shell Programming and Scripting
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
Discussion started by: gauravgarg
6 Replies
8. Shell Programming and Scripting
HI,
We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies
9. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
10. UNIX for Dummies Questions & Answers
Hello
To do :
'automate the process of generating report and send it to client every 15 days after encrypting the report file'
Did so far :
- generate Java program to encrypt the file.
- generate SQL query to run the report.
Is there any body who can help me to go further ?
... (7 Replies)
Discussion started by: cub
7 Replies
cssd(1M) System Administration Commands cssd(1M)
NAME
cssd - daemon which invokes and watches the CSs
SYNOPSIS
/usr/sbin/cssd [-f filename]
AVAILABILITY
SUNWjfpu
DESCRIPTION
cssd is the command which invokes and watches CS available in MLE (Multi Language Environment). After five seconds of the ending (includ-
ing abnormal termination) of a CS, cssd re-invokes the CS.
CS STARTING INFORMATION FILE
In a CS starting information file, /etc/css.conf by default, some CS starting information directories are described. This file can be cus-
tomized. cssd reads /etc/css.conf to get CS starting information directories, and then it invokes all executable files in the directories.
Usually, each CS itself is not placed in the directories and is invoked indirectly from a script in one of the directories.
CS STARTING SCRIPT
A CS starting script is located in a CS starting information directory. cssd reads all CS starting information directories in the sequence
specified in /etc/css.conf and finds to invoke all CS starting scripts. If two or more scripts which have the same filename are found,
cssd invokes only the first one.
UPDATING CS STARTING INFORMAION
When cssd receives signal SIGHUP , it re-reads /etc/css.conf and re-finds all CS starting scripts, and then restarts, starts or terminates
each script according to the following conditions.
A script whose modified time is changed (is to be restarted) A script which is newly added (is to be started) A script which is
deleted (is to be terminated)
TO TERMINATE
When cssd receives signal SIGTERM, it sends SIGTERM to each CS under the cssd's management and terminates itself (in general, each CS also
terminates with the signal).
ERROR INFORMATION
As a facility of daemon, cssd sends error information at level `err' , and invoke/re-invoke information at level `notice' to syslogd(1M).
OPTION
-f filenaSpecify a CS starting information file. Without this option, /etc/css.conf is used.
FILE
/etc/css.conf file for the information of CSs by default
SEE ALSO
css.conf(4), syslogd(1M)
BUGS
If a CS starting script is programmed so that itself is exec-ed by a CS, cssd understands that the process of the CS starting script is
terminated in spite of the CS's termination, and so puts syslog message out.
SunOS 5.10 10 Jan 2003 cssd(1M)