I have a job in SQL Server Agent that has 2 steps. On Success, step 1 is supposed to go to step 2, if it fails it's supposed to quit the job reporting failure. This job is scheduled to run every day.
The problem I'm having is that step 1 seems to mysteriously be skipped about 90% of the time, but step 2 always runs. This is problematic as step 2 depends on actions step 1 being completed. Looking at the job history, I'm not seeing any failures on step 1, just that there is no record of it happening. Does anyone know of a way to troubleshoot this?