sql server - Avoiding the Yellow Triangle when using failed steps for flow control in an Agent job -
i have multi-step agent job in sql server 2012 uses success or failure of job steps flow control. in image below, step 3 checks existence of file powershell script signals failure when file not found. on failure, goes step 7 , sends email. on success (or failure) of step 7, job proceeds step 11 , similar search file.
the job @ 2:34:34 found both files , ran them through ssis package, while job @ 2:27:39 not read files, , sent email effect before signaling job failure. job run @ 2:31:23 functionally succeeded. found no files, popped off couple of emails, , finished.but if step of job signals failure, entire job marked yellow caution triangle.
is there way of using flow control in agent job result in check mark instead of caution?
Comments
Post a Comment