Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER not executing

Andrew ROct 11 2022 — edited Oct 11 2022

Hi All,
I have created a job in Oracle APEX but the job is not working. below is my code

BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'Template5',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN Email_template; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=Minutely;',
end_date => NULL,
enabled => TRUE,
comments => 'This is for Email template'
);
END;
/

But when I run .run_job(below code) it is getting executed...

BEGIN
DBMS_SCHEDULER.run_job (job_name => 'Template5') ;
END;

Could someone tell me how to solve this ?

Regards,
Andrew

Comments

top.gun

OMG - where do I start!

If you are using Oracle for commercial purposes then you or your client needs a licence from Oracle. So really you should stop now.

Once you have your licence from Oracle, you can do a simulated import (ie show metadata) like this:

imp ar/live show=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Then if the above works you can do the real import (ie metadata and data) like this:

imp ar/live full=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Dean Gagne-Oracle

You can always use

imp help=y

to give you the available commands and options.  If you only want the data, then you can use:

imp user/password file=your_file.dmp rows=y

Hope this helps.

Dean

Lisa-Oracle

Hi AJVinkles,

You need to add ignore=y since the table pre-exists

Using IGNORE=y instructs Oracle to ignore any creation errors during the import

and permit the import to complete.

imp user/password file=  log= FROMUSER= TABLES=  ignore=y

rows=y as stated above is the default so it is not needed in the command

Regards,

Lisa

1 - 3

Post Details

Added on Oct 11 2022
#pl-sql, #plsql
0 comments
91 views