• Thanks for the reply. The schedules that I mentioned are just examples. In reality, these schedules will be such that are they are non overlapping. For example, schedule S1 will run every 1 hour on the 20th minute and schedule S2 will run every 2 hours on the 40th minute and so on.

    This is how I have the data stored in the database table that has information about what reports to be emailed to users and the schedules.

    User1 > Report1 > Schedule (S1)

    User1 > Report2 > Schedule (S2)

    User2 > Report4 > Schedule (S2)

    ....

    User4 > Report1 > Schedule (S1)

    So, when the job runs and if I know that schedule "S1" invoked it, then I will know that - Report1 has to be emailed to User1 and User2.

    I hope this makes it clear why I need to know the schedule that invoked the job.

    Please help!