question

MarkN-7787 avatar image
0 Votes"
MarkN-7787 asked MarkN-7787 commented

SSMS Job Status incorrect after completing successfully on second attempt (in SSIS)

I execute a stored procedure that's called from SSIS (in a For Loop) but if the job fails initially I have the system wait and then reattempt to run it. When it does complete the status in SSRS reporting still shows as 'Failed' status despite it having completed successfully (obviously holding the initial status).
Can anyone advise on how I'd update the status to show it has actually run successfully?

Regards,
Mark

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MarkN-7787,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
BjoernPeters avatar image
0 Votes"
BjoernPeters answered MarkN-7787 commented

You are stating that the status shown in SSRS... so you are using a custom built monitoring solution in SSRS for those jobs or at least that one report is created for those purposes...

Maybe you can check with the creator of that report why that report shows only the report of the "first" run on that day and not the "latest"? Maybe the sorting of the result is wrong in that report?


How should we advise you how to update that status if we don't really know what you are doing or using to get that status?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the response. Apologies for not giving more detail in the initial question.

I've also realised I mentioned SSRS which was incorrect.
To get the status on the Job I right click on the folder under 'Integration Services Catalogs', then Reports, Standard Reports, All Executions. It in here that the job is listed as 'Failed', not SSRS. If I click on 'All Messages' I see the job failed down the list due to 'Communication link failure' but then it restarted and run successfully.
Its this job that should show as 'Succeeded' but has a 'Failed' status.

0 Votes 0 ·

Have you tried closing SSMS and re-opening?

0 Votes 0 ·

Hi Naomi. I have. That doesn't seem to make much of a difference.

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered MarkN-7787 commented

Hi @MarkN-7787,

Welcome to Microsoft Q&A!
Please go to Help -> About and check if the version of SSMS is the latest one.
If it is not, you can try to install the latest SSMS from here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
And here is the article about Repair SSMS to fix the problem to prevent SSMS corruption: https://www.prajwaldesai.com/repair-sql-server-management-studio/
If the above information doesn't work for you, you can post your question again on this feedback site.
Hope these could give you some help.

Best regards,
Seeya


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Seeya

Thanks for your response. Much appreciated!
I'll chat to my colleague about your suggestions above and see if we can give those a try. I'll let you know if they work.

Have a good day,
Mark

0 Votes 0 ·

You are welcome!

1 Vote 1 ·

Hi @MarkN-7787,

Hope everything goes well. I'm just concerned about how your questions are going. In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

Hi.
None of the answers really worked so we've found a work around for the time being. It's not an issue that happens very often.
Is there a way I can delete this question?

0 Votes 0 ·