This content has been marked as final. Show 5 replies
You are probably creating the job with the AUTO_DROP argument on default, which is TRUE. So it is dropped after execution.But it is an scheduled job to run every 1am. So it should not be dropped :(. And besides, I can see it where I select user_scheduled_jobs.
My point in searching it in the node tree in sqldev is I want to modify it. For example i want to change the schedule date run. Is there a way to display it on the node tree again? just like when I created it?
SQL> select job_name from user_scheduler_jobs; JOB_NAME ------------------------------ envi_decom_due_job
KinsaKaUy? wrote:And what do you suppose would need to be "sync from the database"?
Ok, my issue is resolved :) I logged out from sqldev and login again. And lo! there it is. Maybe sqldev took long time to sync from the database?
SQL Developer is just a GUI client. It sends SQL statements to the database. It returns results. Some (much) of the sql it sends to the database is what it sends on its own behalf, like selecting from various data dictionary views to populate the navigation trees, but in the end, it's still just a matter of sending sql and displaying the results. Nothing to 'sync'.
Perhaps you just failed to click a 'refresh' button somewhere.
If you have usage issues with SQL Delveloper, there is an entire forum dedicated to it. See SQL Developer