Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


gorkam
2017-02-15T22:36:37Z
I am running the following t-sql code while performing a refresh to TEST. The problem is the DBCC Shrinkfiles are done, but VC still thinks the task is running. I am currently running 8.2.3 VC. I purposely broke up the shrink with checkpoints to keep it from dragging for too long.

Thank you!

DBCC SHRINKFILE (N'Bairds_Build' , 128000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 123000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 118000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 115000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 113000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 110000)
CHECKPOINT
Sponsor
Forum information
Support
2017-02-16T09:21:11Z
We have no experience of that specific command. Not sure why it hangs but it sounds like this would be better off in a stored procedure?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
gorkam
2017-02-16T22:38:43Z
Ok, I can experiment with that. It is a stored procedure already, but I will see if I can come up with a notifier that will help VC know that it's done.

Thank you!
Support
2017-02-17T10:41:00Z
Originally Posted by: gorkam 

Ok, I can experiment with that. It is a stored procedure already, but I will see if I can come up with a notifier that will help VC know that it's done.

Thank you!



If it completes to early it means that your stored procedure spawn of the commands instead of waiting for them to complete.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top