Post reply

SQL agent help

  • March 30, 2024 at 4:16 am

    #4404834

    Hi Guys,

    I have an SQL Agent job. It is called an SSIS Package and is stored in SSIS DB. I can see the SSIS Package completed without any problem. Job has only one step. However, the SQL Agent job never ends. Just for my testing, I created an SQL Agent job and used SQL code to execute it, and it runs and finishes.

    Any advice would be highly appreciated.

    Thanks.

  • March 31, 2024 at 5:10 am

    #4405283

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 31, 2024 at 3:09 pm

    #4405471

    What does the package do? Is there any file system interaction?

    If you open the All Executions report for the package, does that provide any clues as to the issue?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 31, 2024 at 6:59 pm

    #4405523

    Have you checked the logs for the Agent job?

  • April 1, 2024 at 3:59 am

    #4405669

    The package was completed successfully. I checked through the SSIDB category, and it shows run and finished fine. However, the SQL Agent Job keeps running and never stops.

    First, I used basic (log), and when I stopped manually, it just showed that the user had stopped. Second, I used the option "No" logging through the SQL Agent job—still the same behavior.

  • April 1, 2024 at 8:29 am

    #4405779

    rocky_498 wrote:

    I checked through the SSIDB category, and it shows run and finished fine.

    What do you mean by the 'SSISDB category'?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 2, 2024 at 3:56 am

    #4406203

    SSIS DB* sorry typo.

  • April 10, 2024 at 6:24 am

    #4409545

    Check the schedule on the SQL agent job to make sure it isn't running repeatedly.

    Check the advanced settings for the job step and make sure that the job is set to "Complete with success" when the step finishes

     

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply