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.

[Tudor]

Hi Antony!

You need to achieve this on all Items at once(if so you could use a scheduled job to trigger an event which in turn triggers a notification to the Ownership group - you can pass this information via the event) or each item has a predefined time, case in which you need to do a daily check of the time difference between that field and the current moment and just like above trigger again an event, which in turn triggers a notifications.

Hope this helps,

 Tudor

[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.

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. Its a custom field.

Thanks,

Antony