You schedule the procedure using the in built scheduler that exists on the DB. Please see the documentation for how to use the scheduler https://docs.oracle.com/database/121/ADMIN/scheduse.htm there will be a similar page for your unknown Oracle version number.
do you see a scheduler item in your connection tree? if so, open it. you should see 'jobs' under that.
if you don't see these things, upgrade to a newer version, or write the dbms_scheduler code yourself using the docs link provided in the previous reply
I have a procedure named sales_update which updates a table named sales_entry.I need to create a job in SQL DEVELOPER VERSION 2.1.0.The job needs to be created in CST timing daily @ 8 am so as the table sales_entrygets updated by 8 am CST
How do I do that.please help
You 'do that' by specifying the 'start_date' and 'interval' parameters when you execute the DBMS_SCHEDULER.CREATE_JOB method.
The 'start_date' parameter requires a TIMESTAMP WITH TIMEZONE value so you specify EXACTLY the time and timezone you want to use.
Only YOU know how long your job may take to execute so only YOU can determine what time the job should start so that it finishes by 8 am CST.
There are plenty of examples in the Oracle docs
And the DBMS_SCHEDULER doc has ALL of the API specs.
See the CREATE_JOB procedure