I need to send an email notification once in every six months from catalog item form.

[antony4007]

I need to send an email notification to the catalog item owners group once in every six months from catalog item form to review the catalog . How to achieve this ? anyone have an idea? 

Please refer attached screen shot.

[Community Alums]

Create a scheduled job as attached per the screen shot. 

Trigger notification from event. It will work as expected. Please let me know your result. 

[antony4007]

Hi Ganesh,

I created scheduled job as below and make it 10 mins for testing.

2. Created a event as below.

3. Then I created notification as below.

 4. finally i run the scheduled job. Its not working as expected.

Thanks,

Antony

[antony4007]

Hi Ganesh,

I checked the log and found below.

Invalid query detected, please check logs for details [Unknown field u_owner_group in table sysauto_script.

But the field u_owner_group field is available in the form sc_catalog_item.

[antony4007]

Hi Ganesh,

FYI...

The field u_owner_group field is the custom field.

Thanks,

Antony