Hi,
I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database.
On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered so as to send the mails in real time.
Please do assist me in this regard, as i am not able find any such option.
Hi Tyler,
Thank you for your input.
I have now been able to create a job in this regard and run the same, but this results in an error.
The error seems to be related to OS, but i am not aware as to how to get through this
Job:
begin
dbms_scheduler.create_job
(
job_name => 'TPP_SEND_EMAIL_JOB',
job_type => 'EXECUTABLE',
job_action => '/Temp/ENV/code/BIL/users/usrbil01/Hemz/sndmailscrpt.ksh',
repeat_interval => 'FREQ=MINUTELY; INTERVAL=30',
enabled => true,
comments => 'Send Email on ISU update'
);
end;
/
Command to run the job:
[FONT=Courier][SIZE=2]exec dbms_scheduler.run_job('TPP_SEND_EMAIL_JOB');
The job is failing with the error:
[FONT=Courier][SIZE=2][FONT=Courier][SIZE=2]ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing extjob wrapper failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: sjsec 3
Please do assist me getting over:
> Error as above
> Is "repeat_interval" mandatory here, I want to execute this job from within a trigger as and when the trigger is executed without specifying a timeline for its execution(Minutely,hourly etc..).
Is this possible, if not please suggest me a way forward.
I am running out of time for my delivery on this
Hi,
Firstly, Thank you for the input.
Below are my requirements:
> I have to send mail in html format having dynamic fields like (name,address etc..) which may change from person to person the mail is sent for.
> The template for the mail has to be configrable i.e, it is constant as of now but may be changed in future.
I have also been able to gather a few information about the utl_mail package in 10g which may solve the purpose of sending mail through database, but I am not able to find out if that supports sending email in html format and also support of dynamic data and configurable template.
I see most of this possible in unix, hence lokking at a job from database.
Please do let me know if i can expedite one of these approaches subject to my time lines