Recently Completed Oracle PL/SQL Training – Looking for Automation Ideas with Allround Tools

[cerey27873]

Hello Allround Automations Community,

I recently completed Oracle PL/SQL training and am now interested in automating some of the database tasks and workflows I’m working with.

I’m curious if anyone has experience integrating Oracle PL/SQL scripts with automation tools like AutoMate, PowerShell, or similar products? Specifically:

What are the best approaches for running and scheduling PL/SQL scripts through automation tools?

Any tips for error handling and logging when automating database operations?

Examples of common tasks you’ve successfully automated involving Oracle databases?

I’d appreciate any advice or examples you can share!

Thanks in advance,

 

[WexSoft]

I don't have experience of using other automation tools, but Oracle provides the DBMS_SCHEDULER package to allow you to schedule/automate database tasks all you want. You can create scheduler jobs to run procedures and/or functions that perform database operations, run reports etc. For example, we have a scheduler job that runs every hour on the hour during the working day and generates reports that are emailed as email attachments (Excel 2003 XML format) to designated users.

 

[CoffeeK1d]

I use DBMS_SCHEDULER mostly also on Linux we have a couple of cron jobs (equivalent to Windows Scheduler), finally, we also use SQL*Plus. It all depends on the problem you are trying to solve, which would be the best tool.