Oct 17
Note to myself: How to easily count the number of Jobs in SQL Server Agent Jobs?
This is just another post for the sake of my mental sanity because I’m always tired of looking up for this over and over again While working on BizTalk
Sep 21
SQL Script to monitor BizTalk Server SQL Jobs
For those who've been following my work, you might recall that I shared a set of PowerShell scripts a while back for monitoring BizTalk Server One of these
Aug 17
The job failed. Unable to determine if the owner (domain\username) of job job-name has server ac...
I recently received a request for help from a customer about a problem that has started to occur with SQL Server jobs in BizTalk Server Everything was working
May 20
BizTalk Server 2016 and SQL Server Integration Services (SSIS) 2016: Connecting to the Integratio...
Last blog post I wrote about an “Access is denied” error while trying to connect with SQL Server Integration Services (SSIS) Today’s post is about the
Aug 29
Backup BizTalk Server job failed. Executed as user NT SERVICE\SQLSERVERAGENT. Cannot open backup ...
Another day, another error to report directly retrieved from my backlog to be published Today is about another error that can happen on the Backup BizTalk
May 9
Backup BizTalk Server job failed. Executed as user: NT SERVICE\SQLSERVERAGENT. Could not connect ...
In my last post, I described how can you fix the issue regarding: Executed as user: BIZDEMO\saspereira Could not find server 'BIZDEMO' in sysservers Verify
May 8
Backup BizTalk Server job failed. Executed as user ”. Could not find server in sys.servers....
After you install and configure a BizTalk Server Azure Virtual Machine, the first time you try to run the main BizTalk Server job: Backup BizTalk Server
Oct 9
DTA Purge and Archive (BizTalkDTADb) job: Procedure or function dtasp_PurgeTrackingDatabase has t...
I normally advise my clients or partners to “religious” follow the order and steps of my BizTalk Server Installation and Configuration guide, an advice
Jun 5
Backup BizTalk Server (BizTalkMgmtDb) job failed with BACKUP LOG cannot be performed because ther...
Recently, I was writing a new article “BizTalk Server Tips and Tricks: How to Backup (other) BizTalk Custom Databases” (that will be released soon as a
Apr 6
BizTalk DevOps: Monitor your BizTalk environment using PowerShell – SQL Agent Jobs Monitoring (Pa...
One of the principal needs for BizTalk Administrators is the ability to monitor the health of BizTalk environments on a regular basis and react promptly to
