Laur IVAN

Delete Executions in Rundeck – Wrapping it all Up

Posted by in IT, Software, Tutorial

The previous posts have built the components to allow us to get projects, jobs, executions and remove executions from a Rundeck instance via its API. Now, we can just wrap them up :) The list of packages we need is:

For convenience, I’ve declared a bunch of constants we can use throughout the project:

As we already have all the helper functions defined, we only need to wrap them in a convenient execution command:

The logis is fairly simple: Get the list of projects For each project,…read more

Delete Dependent Entries of a Table in Oracle PL/SQL

Posted by in Software, Tutorial

The other day I had a task to clean up a database which was populated with a list of records. Unfortunately, my main table is linked to a host of other tables via foreign key dependencies and, to make things worse, no CASCADE constraints are specified. The process I want to is as follows: Scan main table First, we need to find the records in the main table we want removed. This is a simple SELECT statement:

In my case, the statement is:

(the 80, and 122 are…read more

Change a Domain Renewal Order on Blacknight Solutions

Posted by in IT

Recently I’ve received a renewal order for domain hosting on Blacknight. Last time, the domain was renewed last year and I wanted to renew it for a longer period (3 years). After a brief chat with the billing customer support, I’ve came up with a list of simple steps, which I’ll be enumerating below. A little experiment: If you find this post and ad below useful, please check the ad out :-)