Export All Scheduled Jobs - version 5.4

Toad Data Point
1

Hello,

Is there a way to export all jobs with details? I am using Toad Data Point version 5.4.0

Thanks ~ Jean

2

Assuming you mean scheduled jobs as one might find on an Oracle database. Short answer is no, not directly in TDP's GUI. Although the Tabbed mode of the Object Explorer does show other object types like Procedures, Functions, Triggers, etc. TDP doesn't show the scheduled jobs.

However, you might be able to find a script that you can execute within TDP's Editor, assuming you have proper permissions to execute... something like the following will return the DDL code for a job named "G1" in one of my Oracle schemas...

select dbms_metadata.get_ddl('PROCOBJ','G1') JobDDLcode from dual

Hope this gives you some ideas for a work-around.

3

Hello,

Thanks for the quick reply. Does this apply to the Task List? I'm scheduling a lot of jobs using the Windows Scheduler used by Toad Data Point. I was hoping to get a list of my monthly jobs I'm scheduling.

Thanks ~ Jean

4

Hi - if you are looking to get a list of the scheduled tasks you can visit Weekend Scripter: Use PowerShell to Document Scheduled Tasks - Scripting Blog (microsoft.com) to learn how to use powershell to export the list of scheduled jobs from the windows task scheduler.

5

Thank you, Julie

I will take a look.

Jean