Customizing the email subject for a new profile

Contributors akseldavis Download PDF of this page

You can customize the email subject for the new profile when you create it.

You can customize the email subject by using the {profile}_{operation-name}_{db-sid}_{db-host}_{start-date}_{end-date}_{status} pattern or enter your own text.

Variable name Description Example value

profile

Profile name used for the database operation

PROF1

operation-name

Database operation name

Backup, Data Backup, Data and Archive Logs Backup

db-sid

SID of the database

DB1

db-host

Name of the host server

hostA

start-date

Start time of the database operation in the mmdd:hh:ss yyyy format

April 27 21:00:45 PST 2012

end-date

End time of the database operation in the mmdd:hh:ss yyyy format

April 27 21:10:45 PST 2012

status

Database operation status

Success

If you do not provide any value for the variables, then SnapManager displays the following error message: Missing value(s) -subject.

  1. Enter the following command: smo profile create -profileprofile [-profile-passwordprofile_password] -repository-dbnamerepo_service_name-hostrepo_host-portrepo_port-login-usernamerepo_username-database-dbnamedb_dbname-hostdb_host [-siddb_sid] [-login-usernamedb_username-passworddb_password-portdb_port] [-rman {-controlfile | {-login-usernamerman_username-passwordrman_password-tnsnamerman_tnsname} } ] -osaccountosaccount-osgrouposgroup [-retain [-hourly [-countn] [-durationm]] [-daily [-countn] [-durationm]] [-weekly [-countn] [-durationm]] [-monthly [-countn] [-durationm]]] [-commentcomment][-snapname-patternpattern][-protect [-protection-policypolicy_name]] [-notification [-success-emailemail_address1,email_address2-subjectsubject_pattern] [-failure-emailemail_address1,email_address2-subjectsubject_pattern]]

The following is an example showing the email subject pattern:

smo profile create -profile sales1 -profile-password admin1 -repository -dbname repo2 -host 10.72.197.133 -port 1521 -login -username admin2 -database -dbname DB1 -host 10.72.197.142 -sid DB1
-osaccount oracle -osgroup dba -profile-notification -success -email admin@org.com -subject {profile}_{operation-name}_{db-sid}_{db-host}_{start-date}_{end-date}_{status}