I need immediate help with this code. I do want to through the output of query into the log file and then on behelf of result i do want to automate an email warning system. while compiling this code i failed to through the output into the log file.
To avoid manual password change for our users we need to automate process of password expiry. We have to inform and ask user to change the password before the password get expire.
Action Points:
· Apply logic in Linux script based on output of expiry query to fetch username and\ no. Of days to expire. Follow suggestion to start with.
Mail will be send to each user whose password will expire in 15 days with Message 'Please change your password from web application as it will expire in x no. of days'.
If it's Oracle, you can also create a stored proc using UTL_SMTP and send the emails from within Oracle. If you're interested, you can google it and find many examples of how to set it up.
Hi,
I have a DB2 UDB 9.7 SQL script, as follows:
I need to pass the script into Unix and generate a fixed length file from this.
Can someone kindly provide a script to achieve it?
SELECT
CAST(COALESCE(CL_ID,'000000000') AS CHAR(9)) AS CL_ID
,STATUS... (5 Replies)
I have installed sSMTP and set it up to use my gmail.
Sending from cli does work fine:
msg file:From: test@gmail.com
To test2@gmail.com
Subject: test post
This is a test
Executing from console:ssmtp -t < msg
does work fine.
But from script it does not work:#!/bin/sh
ssmtp -t < msg... (0 Replies)
Hi
I have a data with varying length i need to convert it to data of fixed length 1000 by appending blank spaces. This has to be done only for specific records i tried with awk but it not happening.
Pls suggest me some advices
awk '/^500/ {$0=sprintf("%s%t" w-length "s", $0,x)}1'... (12 Replies)
I have a peculiar file with record format like given below. Each line is wrapped to next lines after certain number of characters. I want to concatenate all wrapped lines into 1.
Input:(wrapped after 10 columns)
This is li
ne1
This is li
ne2 and
this line
is too lo
ng
Shortline
... (8 Replies)
Hi Experts,
There is a shell script that accepts positional parameter between 1-25 to execute case statement of script depending upon the parameter passed.
Now I need to run all the 25 sessions parallely. In each option of case statement it is connecting with sqlplus and executing a select... (11 Replies)
Need a script that manipulates a fixed length file that will compare 2 fields in that file and if they are equal write that line to a new file.
i.e. If fields 87-93 = fields 119-125, then write the entire line to a new file. Do this for every line in the file. After we get only the fields... (1 Reply)
Hi ,
I am working on the following script . I want this script to run and scan the log file repeatedly after 3 hours. This script will run & scan just for the current date logs and after every 3 hours. Kindly advice what to add in this script for this purpose.
#!/bin/sh
diff common.log... (3 Replies)
Hi,
I need to write a shell script.
Based on command line param to script say demode=yes
Need to run an ant command for an hour(configurable)
Then exit
Again run the ant command
all this needs to be in a loop.
Thanks in advance
Raj (1 Reply)