Iinterview: "when the change request is in any state till "schdule for approval "

Here's a solution outline based on your requirements for automating the change request process in ServiceNow:
Solution Outline for Change Request Management in ServiceNow
1. Condition Check:

• Create a scheduled job (or a Business Rule) that runs daily to check for change requests that meet the following criteria:
  • The change request is in any state up to \"Scheduled for Approval.\"
  • The scheduled end date has passed.

2. Notification Trigger:

• For each qualifying change request:
  • Send Notification 1: Trigger the first notification email to the change assignee, reminding them to cancel or reschedule the change.
  • Wait 2 Business Days: Use a timer or business duration check to wait for 2 business days.
  • Send Notification 2: If no action has been taken after 2 business days, trigger the second notification email.

3. Auto-Cancellation:

• After the second notification, check again if the change request has been actioned:
  • If no action has been taken (i.e., it is still in the same state), automatically:
    • Cancel the change request.
    • Update the change assignee to indicate the cancellation.

4. Handling Cancelled Tickets:

• Ensure that the system updates the status of the cancelled ticket so that it cannot be reopened.
• Implement functionality to allow the cancellation of a ticket to be copied to create a new change request.

Implementation Steps:

1. Create Scheduled Job:
   • Use a scheduled job in ServiceNow to run a script daily that checks for change requests meeting the specified conditions.
2. Notification Emails:
   • Set up email notifications using Notification Emails in ServiceNow. Use conditions to ensure emails are sent to the correct assignee.
3. Business Rules:
   • Create Business Rules to handle the transition from scheduled to cancelled states and to ensure that notifications are triggered at the right times.
4. Script for Auto-Cancellation:
   • Write a script that automatically changes the state of the change request to \"Cancelled\" and updates the assignee after the second notification if no action is taken.
5. Copy Functionality:
   • Implement functionality to allow users to copy details from a cancelled change request to create a new one.Created  a Schdulejob and after Business rule for testing purpose i took 5 mintues of duration.
     
   • 
   • 
   • 
6. Unfortunatly the notifications are not triggered and i missed the logic for calculating the time , can anyonce came across this senario?Thank you .