Send Email using Task Scheduler

Requirement – Task scheduler to send any file as attachment.

 

Prerequisite – Should have SMTP details for any available email service

 

Resolution – Task scheduler has send email option, which is not helpful and people face many issues.

sendEmail is one utility, which can be used to fulfill the need. Download this executable file and save at system.

1.        Create a task in scheduler
2.        Select action- Run a program
3.      Give the sendEmail.exe in file name

1.  Start in (optional)=path of sendEmail.exe in your system
2.  Add arguments (Optional) – provide mailing details as mentioned below -

-f sandeep19rm@gmail.com -u Test Email -m Here is the Email Option! -a sandeep.txt -t sandeep@oalearning.com -cc learning@oalearning.com -s smtp.gmail.com:587 -xu username@gmail.com -xp password -o tls=yes

 

Options :

-f	From Email Address
-u	Mail Subject
-m	Mail Body
-a	Attachment file name
-t	To Email Address
-cc	CC Email Address
-bcc	BCC Email Address
-s	SMTP details (server:port)
-xu	Username
-xp	Password
-o	Mailing options

 

 
 

 

Windows Task Scheduler

This article is nowhere related with EBS, but will be useful for any computer users.

 

Requirement – Automated process to be executed on schedule basis in windows.

Wanted to ensure if there exist any specific file in system, I should be alerted with details.

 

Solution – Window provides task scheduler to achieve same. Task scheduler is same as oracle triggers with GUI.

 

How to find - Login to windows >> Start>> Task Scheduler

 

Create Task – Click on create Task action  

 

 

General Tab – Set the task name and description and click on Triggers

 

Triggers – This tab is to set the execution time. It can be set to run on schedule or on demand. Click on New button or edit existing schedule.

Provide scheduling detail and move to Actions

Actions- This is to perform different activity. It can run a program, send email or display messages. Click new button to set a new action.

Action = start a program   Program Name = Path of executable file.

We can give the file name only and place path in Start in (optional) block.

 

Conditions – To set various conditions when task should run and when not.

 

Settings – This is to define different instance scenarios.

 

Press OK and it will pop up the windows login password. Task will run at defined schedule.