Hi every one? I have a job scheduled to run a SSIS Package in SQL-Agent. Now, In my package, it has a retring process to resume the task that query data from WMI from some VMs. when the VM is down, the query is failed, then the retry can make it success, if the VM is up. And currently, it works, but when the resume has been executed and succeed, in the SQL-Agent, the Job(which host the package to run), is still markup as FAILED! That's, is there any way to force the status as SUCCESS? Even if the process goes into the retring(this means the first time, the WMI query is failed.but later, it will succeed).

It is in the job step definition itself, set quit the job reporting Success on failure.Arthur My Blog