All my sql jobs were working well until the recent two months.
On weekends, when traffic tends to be high, serveral sql jobs would run smoothly through the steps of Transact-SQL Script and then hung at the ActiveX script steps.
Anyone has encountered similar issues?
I was wondering if it could be due to connections issue since the sql jobs have been working well on weekdays.
Platform: Sql Server 2000 running on Windows 2000 server