March 30, 2024 at 4:16 am
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
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
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?
March 31, 2024 at 6:59 pm
Have you checked the logs for the Agent job?
April 1, 2024 at 3:59 am
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 2, 2024 at 3:56 am
SSIS DB* sorry typo.
April 10, 2024 at 6:24 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy