PrepAway - Latest Free Exam Questions & Answers

Tag: how to remove [sqlstate 01000] from sql server agent job output file

What should you do?

You are responsible for maintaining scheduled jobs for the SQL Server 2005 databases in your department. One of the jobs aggregates data from multiple sources for reports. This job runs daily. The job consists of multiple steps. Each step aggregates data for a specific report. A user reports that the data for some of the reports has not been updated recently.
You need to ensure that every step of the job that aggregates data executes even when errors occur. What should you do?