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

Mark N 1 Reputation point
2022-05-10T10:47:10.717+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,644 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2022-05-10T12:07:04.077+00:00

    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?

  2. Seeya Xi-MSFT 16,436 Reputation points
    2022-05-11T05:46:06.83+00:00

    Hi @Mark N ,

    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://learn.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.