YOU HAVE CREATED A MULTI STEP JOB TO PREPARE DATA FOR AN IMPORTANT...

5. You have created a multi step job to prepare data for an important weekly production report. The job consists of several steps: getting data from multiple servers, consolidating it into a single table, and producing a report. Your users have complained that several times no report was created because certain servers were unavailable. They tell you that they would rather see a report based on last week’s data than not see a report at all. What should you do to satisfy your users?A. Change Step 2: Create Report runs only On Failure of Step 1: Consolidate Data.B. Change Step 2: Create Report runs On Success and On Failure of Step 1: Consolidate Data.C. Rearrange the job steps so that Create Report is Step 1 and Consolidate Data is Step 2.D. Rearrange the job steps so that Step 1: Consolidate Data runs on failure of Step 2: Create Report.