Timeline for What does it mean to reach a stable point during the execution of a job?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 12, 2022 at 13:16 | vote | accept | Ronaldo | ||
| Apr 12, 2022 at 13:06 | comment | added | Dan Guzman |
@Ronaldo, the insert script is running in a tight loop so the number of rows inserted before the script actually stops can be significant if you have a fast machine and storage. On my workstation (high-end processor and SSD storage), over 200 rows were inserted between the sp_stop_job and the attention signal to cancel the script. I saw no additional rows after adding WAITFOR DELAY '00:00:00.100'; after sp_stop_job.
|
|
| Apr 12, 2022 at 12:29 | comment | added | Ronaldo | Thanks, Dan Guzman. I didn't expect the SQL Server Agent to take that long (time enough to insert more rows on the table) to respond to the stop signal. I noticed the problem on an instance on my desktop, so SQL Server wasn't busy to justify the delay. | |
| Apr 12, 2022 at 11:15 | history | answered | Dan Guzman | CC BY-SA 4.0 |