Here are some of the settings: DB instance id - database-2 Endpoint - database-2.eu-central-1.rds.amazonaws.com Port - 3306 Public accessibility - true DB name - Stack Exchange Network Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share. DBeaver is an open source tool with 11.2K GitHub stars and 989 GitHub forks. Here's a link to DBeaver's open source repository on GitHub. Zencom, Nutmeg, and Datatree are some of the popular companies that use DBeaver. It's also compatible with Amazon RDS and Microsoft Azure, which we also use. Amazon Relational Database Service: Mysql: Connection Refused from hosting: Mar 31, 2021 Amazon Relational Database Service: Aurora reader storage cost: Mar 31, 2021 Amazon Relational Database Service: How to connect to RDS from DBeaver.
This is returning the result set IN SSMS, but I don't know how I query the result set returned, so I can get at the column data. For example getting the lifecycle output parameter returned by this proc.
I would ideally like to call this every 10 seconds until I get a lifecycle status back as SUCCESS
Any help on how to achieve this is gratefully received.
Regards,
Andy.
Did you read the manual?
Tracking the Status of Tasks
Dbeaver Amazon Rds Account
To track the status of your backup and restore tasks, you call the stored procedure. If you don't provide any parameters, the stored procedure returns the status of all tasks. The status for tasks is updated approximately every 2 minutes.
To track the status of your backup and restore tasks, you call the rds_task_status stored procedure. If you don't provide any parameters, the stored procedure returns the status of all tasks. The status for tasks is updated approximately every 2 minutes.
If you call it even 1/10 of a second, it won't do anything except increasing the network traffic and the bottom line of the bill from Amazon.
Dbeaver Amazon Rds Customer Service
Dbeaver Amazon Rds Login
As for the catching the output - did you try to insert the resultset into a table?