Require help for Reporting schedule job

[suresh m2]

Hi Team,

There was a new requirement for change module, Based on the plan start date we need to check the every week Thursday after 1 PM to next week Thursday before 1 PM what are the changes are in pending approval, those changes we need to send the notification.

We have queried but The time is not work as we are unable to add time stamp in the query.

Can any one help us? with above requirement.

Thanks,

[Ankur Bawiskar]

@suresh m2 

please share what you are using currently?

[suresh m2]

Hi Ankur,

Thanks for reply 
Actually i have used list view query in change table and created scheduled job with query i have pasted in attachment ,My requirement is Every week Thursaday 1pm - to next week Thursday 1pm pending approval need to displayed with query and need to scheduled notification.