Practice Example with Scheduled Jobs

In the previous learning content, we examined the Scheduled Jobs view mode. In this learning content, we will use the email design we prepared earlier to automatically send a celebration email at 9:00 on the employee's birthday.

Let's get started!

1. Open Scheduled Jobs view mode.
2. In Scheduled Jobs view mode, create a new Scheduled Job named BirthdayMail.
3. First, create a SQL action named CheckBirthDaysMail that checks and lists birthdays through the Custom Actions panel on the left. The SQL action shown on the screen will help you with this.

select String_AGG(Email,',') as Mails from Employee where FORMAT(BirthdayDate,'MM-dd') = FORMAT( GETDATE() ,'MM-dd')

1. Then, let's create the Scheduled Job setting that will automatically send the birthday e-mail to the staff at 9 am on the relevant day.
2. In Scheduled Jobs view mode, select Specific second>0 as the Second setting.
3. Select Specific minute>0 as the Minutes setting.
4. Set Hours to Specific hour>9.
5. Select Every day for Day and Every month for Month.
6. Finally, select any year for the Year setting.
7. After making Scheduled Job settings, let's add actions via the Properties panel.
8. First, add the action that checks and lists birthdays by selecting ADD ACTION>Custom>Managed DB>CheckBirthDaysMail.
9. Then add SendMail action from Notification actions via ADD ACTION.
10. Under SendMail action, select Template as MailType.
11. Select Birthday from the Template drop-down menu.
12. Click Symbol Picker in the Receiver parameter and select ActionResults>CheckBirthDaysMail>First>Mails to send e-mail to employees with birthdays.
13. Enter Happy Birthday! as a Fixed Value in the Subject field. Enter the phrase.
14. Finally, save the Scheduled Job by clicking the UPDATE button.

With these operations, we have created a working Scheduled Jobs example together. By applying similar operations, you can prepare Scheduled Jobs specific to your own needs.

‍