Customizing the email subject for a new profile
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.
-
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}