Customizing the email subject for a new profile

Contributors

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}