You are the database administrator of your company. You are responsible for managing all databases stored on a SQL Server 2008 computer named SQL1.
You create a job with multiple steps that collects data from multipletables for reporting purposes. Each job step collects data for a particular report.
You configure the job to run daily. Users report that data for several reports is not updated regularly. You suspect that all steps configured in the jobare not being performed.
You want to ensure that each job step is performed even when if an error occurs. What should you do?