SSIS Job Status -Sql server job Agent

San 161 Reputation points
2023-07-21T07:27:53.5+00:00

Dear Experts,

I have SSIS jobs that have 7 steps that are scheduled to run via Sql server agent daily basis. I want to monitor this job and send an email about the job status.

Need to write a query that shows only the current date

If the job succeeds then "Sucess" along with that sends the time when it's completed.

  1. If failed then shows the status "Failed" What step is failed? and failer alert must be in Red
  2. If running then shows the status "In Progress"

Please help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,477 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,643 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft Vendor
    2023-07-26T06:23:19.7933333+00:00

    Hi @San

    Did Olaf's answer help you? I also found the following link, maybe you can use it as a reference: https://www.sqlshack.com/reporting-and-alerting-on-job-failure-in-sql-server/.

    If the answer was helpful, please click Accept Answer so others with similar questions can find it quickly. Please feel free to let me know if you have any questions.

    Best regards,

    Aniya

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 46,041 Reputation points
    2023-07-21T07:49:22.59+00:00

    You can use the existing build-in feature Notify an Operator of Job Status

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.