How to send notification emails with attachment in Navicat DB Admin tool

One of the nice features of Navicat is its ability to send notification emails along with attachments such as exported files. So, here in this tutorial, we will show you how to send personalized emails along with attachments while scheduling the Export job.

Step 1: Before starting the tutorial, I am assuming that you already have created an export profile for your Database table. If not then select the Database and then Export Wizard. Follow it to create an Export profile.

Export profile wizard

Export profile wizard

Step 2: Now, click on Automation and select New Batch Job button.

Create new automation job

Create a new automation job

Step 3: After that, select the Export from the Job area, the Database and then double click on the available job to add it to the General area.

Select the Export profile

Select the Export profile

Step 4: You will see the job in the General area, select to highlight and click on the Add Attachment button.

Add attachment to export job to send with notification email

Add an attachment to export job to send with the notification email

Step 6: To set the email recipient, select the Advanced tab and check the Send Email box. Enter all the mail server details along with the recipient, if you want to send a notification along with the attachment to multiple people, simply enter their email addresses separated by a semicolon.

If authentication is needed, check it and furnish the credentials.

Fill SMPT server details in Navicat

Fill SMPT server details in Navicat

 

Step 7: Now, save the Batch Job.

Save the Automation job

Save the Automation job

Step 8: You can immediately execute the created job by clicking on the Start button, however, for Scheduling click the Set Schedule Task button and select the Trigger Tab followed by New button.

Set Navicat schedule task

Set Navicat schedule task

Step 9: Set the frequency of repeating the batch job along with the date and time. Click the Ok button to save the task.

Scheduling

Scheduling

Step 10: Everything is set now, as per your schedule time, the Navicat will automatically execute the task, however, for the tutorial, here we are executing it manually to show you the message log.

Message log Navicat

You can see Navicat has successfully sent a notification mail along with attachments. Let’s see how the received email looks like. Here is the email which one of our set recipients got along with attachments.

Notification mail along with attachments

Notification mail along with attachments

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.