Database Administration (MOSC)

MOSC Banner

Sending job completion from shell script, help needed.

edited Sep 6, 2019 5:03AM in Database Administration (MOSC) 37 commentsAnswered
  1. Project scope: Locking few users and sending them email that has to be automated.
  2. Issue: the mailx part isn't working as I need help on how to input the options for mailx.
  3. DB server: AIX 7.x
  4. My work so far: I have a file F1 that has the below.
alter user x1 account lock; alter user x2 account lock;

5. I have the mailx part of the shell script (in Ksh) for single users as below:

mailx -s "WARNING - $ORACLE_SID User X1 Account Locked" -c "manager@xyz.com" "manager@xyz.com x1@xyz.com" 

For multiple users:

a. how to input x1, x2... into mailx command from file F1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center