I want to extract the data from IICS portal about the job run status.
Budget: ₹1,500 – ₹12,500 INR
This program is supposed to run everyday and extract the information on the list of jobs & it's run status & update the excel sheet with the latest information.
The format in which the job details are updated are enclosed in the excel
The details on the script are as follows:
1. It should run at every 2 mins interval
2. Initially the script will look for the first job that ran today, if it finds then it'll update the first 2 column i.e. Run Date & Run time.
3. It should then copy all the 57 jobs as rows which is the set of jobs that will run in sequence for that schedule
4. Then it'll keep checking if the job is completed, by checking if the End time is updated
5. If the end time is not updated then it means the current job is running and no need to check the following jobs untill this is completed
6. The status should be updated based on the subtask of the job, if any of the subtasks had a warning, then it'll show the status as Warning
7. Upon an error the status should be updated Failed or suspended and keep checking untill a new run occurs and it's successful
8. On a given day there could be multiple runs for the same job, it should pick the latest run details to update the status
We can discuss further if you have any queries.
The format in which the job details are updated are enclosed in the excel
The details on the script are as follows:
1. It should run at every 2 mins interval
2. Initially the script will look for the first job that ran today, if it finds then it'll update the first 2 column i.e. Run Date & Run time.
3. It should then copy all the 57 jobs as rows which is the set of jobs that will run in sequence for that schedule
4. Then it'll keep checking if the job is completed, by checking if the End time is updated
5. If the end time is not updated then it means the current job is running and no need to check the following jobs untill this is completed
6. The status should be updated based on the subtask of the job, if any of the subtasks had a warning, then it'll show the status as Warning
7. Upon an error the status should be updated Failed or suspended and keep checking untill a new run occurs and it's successful
8. On a given day there could be multiple runs for the same job, it should pick the latest run details to update the status
We can discuss further if you have any queries.