SQL Server scheduled Job failing

Amy Jandreau 61 Reputation points
2021-03-15T16:00:33.523+00:00

Hi All
I have an SSIS Package that i scheduled as a SQL Server job. The job has been failing lately all of a sudden. The error message i get is the excel work book has been opened, which is not the case as i made sure it is closed. Please advice.
Thanks

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,793 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-16T06:07:11.067+00:00

    Hi @Amy Jandreau ,

    Please share more detailed error messages in the job View History.

    Please check if you run ssis package in other progress at the same time.

    78104-job-viewhistory.png
    78121-jobhistory.png

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.