Restoring Deleted Jobs

Overview

You have accidentally removed a job from the web portal and need to recover it.

Solution

Submit a ticket to StreetSmart support, including the information about the job that needs to be restored:

• Date and time when the job was deleted or created
• Name of the job
• Name or phone number of the worker assigned to the job
• Company ID (if you have several company accounts)

<supportagent>

L2 agents should perform the following steps:

1. Connect to the database.
2. Find the job mentioned by the customer.
   You can use the following query or customize it according to the customer's case:

   SELECT *
   FROM PSTS_T2PROD_COBRA_PROD.job
   where co_id=XXXXXX AND
   NAME LIKE '%<name provided by the customer>%' AND
   DELETE_UTC IS NOT NULL;

   Note: Name of the job is case sensitive - you may want to remove it if the job is not found. 
   
   • You can also specify the deleted time as a range (modify only the dates in bold):
     

     DELETE_UTC BETWEEN TO_TIMESTAMP ('09/24/2020 06:00:00 PM', 'MM/DD/YYYY HH:MI:SS AM')
     AND TO_TIMESTAMP ('09/26/2020 11:30:00 PM', 'MM/DD/YYYY HH:MI:SS AM')

   • To search for a job assigned to a specific user, find their user ID in CSU and add the following line to the query:

     CURRENT_USR_ID=xxxxx

     
     
     
     
3. If you are not sure if you found the exact same job mentioned by the customer, double-check with the requester if it is the job that needs to be restored.
4. Escalate the request to the SaaS team, including the query you used to find the exact job that needs to be restored.
5. Once SaaS confirms that the job is restored, check if it is visible on the customer account as described in the Testing section and then inform the requester.

</supportagent>

Testing

1. From the web portal, navigate to Jobs > Job List.
2. Using filters, select the required date range, group, and job status.
   The job should be displayed on the page:
   
   

Back to top