Amazon RDS - End Session

Declaration

<AMAWSRDS ACTIVITY="end_session" SESSION="text" />

Description: Ends an RDS session.

IMPORTANT: RDS activities are performed using Amazon's Relational Database Service engine, therefore, administering Amazon RDS requires a valid Access Key ID and Secret Access Key.

Practical Usage

Used to end a session previously created and started by a Create Session step.

Credentials Parameters

Property

Type

Required

Default

Markup

Description

Session Name

Text

Yes

(Empty)

SESSION="RDSSession32"

Specifies the name of the session to end.

Description tab - A custom description can be provided on the Description tab to convey additional information or share special notes about a task step.

Error Causes tab - Specify how this step should behave upon the occurrence of an error. (Refer to Task Builder > Error Causes Tab for details.)

On Error tab - Specify what AWE should do if this step encounters an error as defined on the Error Causes tab. (Refer to Task Builder > On Error Tab for details.)

Example

The sample AML code below can be copied and pasted directly into the Steps panel of the Task Builder.

Description

  • Step 1 - Create RDS session "MySession" Amazon web service access key is "AKIAJU2LHLMG6BA6BZTA". Use https.

  • Step 2 - Create RDS database instance "myRDSDatabase". Instance type is "db.m1.small". Launch database in "us-east-1a" zone. Master user is "myName". Port is "3306". Session is "MySession".

  • Step 3 - Modify database instance "myRDSDatabase". Instance type is "db.m1.large". Database size is "10". Apply immediately, Session is "MySession".

  • Step 4 - Create snapshot "rdsSnap" from Rational database service database instance "myRDSDatabase". Store Rational database service database information into dataset "theSnap". Session is "MySession".

  • Step 5 - Reboot instance "myRDSDatabase". Session is "MySession".

  • Step 6 - End RDS session "MySession".

<AMAWSRDS ACTIVITY="create_session" ACCESSKEY="AKIAJU2LHLMG6BA6BZTA" 
SECRETKEY="AM3m5RnKS1eh50=aME" USERAGENT="AutoMate" 
SESSION="MySession" />
<AMAWSRDS INSTANCEID="myRDSDatabase" 
INSTANCETYPE="db.m1.small" ZONE="us-east-1a" 
MASTERUSER="myName" MASTERPWD="AM16wP88TJPA0FX78Oon4bvjg==aME" 
PORT="3306" STORAGE="5" PROVIDER="session_based" 
SESSION="MySession" />
<AMAWSRDS ACTIVITY="modify_instance" 
INSTANCEID="myRDSDatabase" INSTANCETYPE="db.m1.large" 
STORAGE="10" APPLYFAST="yes" PROVIDER="session_based" 
SESSION="MySession" />
<AMAWSRDS ACTIVITY="create_snapshot" 
SNAPSHOTID="rdsSnap" INSTANCEID="myRDSDatabase" 
RESULTDATASET="theSnap" PROVIDER="session_based" 
SESSION="MySession" />
<AMAWSRDS ACTIVITY="reboot_instance" 
INSTANCEID="myRDSDatabase" PROVIDER="session_based" 
SESSION="MySession" />
<AMAWSRDS ACTIVITY="end_session" 
SESSION="MySession" />