dbms_scheduler: wish I could generate sql for a job

[Patrick Holmes]

I can view a table and then press the [View SQL] button to generate sql to recreate the table (although it doesn't include grants unfortunately...) The "DBMS Scheduler..." tool has a [View SQL] button too, but I can't get it to work. I would like to generate the SQL for a dbms_scheduler job to make a backup before making changes, or to copy the job to a another dev/test database, for two examples. Is there a way to make this [View SQL] button work? Or do you plan to fix this in a future version? I am using version 9.0.6.1665, with an Oracle 10g database.
(PL/SQL Developer is one of my all-time favorite programs... Thanks for making it available!)
thanks,
pat

 

[Marco Kalter]

This has been added for version 10.0. The "View SQL" button now shows the creation commands when you have not made any changes, just like the table definition editor.