Hello,
I’ve recently implemented a MSX/TSX jobs environment in my organization.
I’ll blog about it at a different time.
Source: Microsoft.com
PROBLEM:
Everything seams to work fine with no issues, except for a strange error message in the SQLAGENT.OUT log:
[419] Unable to open or read TSX cache file ‘E:\MSSQL10.DB\MSSQL\JOBS\TSXCACHE.BIN’ (win32 error code: 2)
Despite the error above, there’s no issues with the implementation – all jobs are working as expectantly.
SOLUTION:
The solution to the problem is to give the user account of the SQL Server Agent modify permissions to the directory:
<SQL SERVER DIRECTORY>\<MSSQL SID>\MSSQL\JOBS
After giving the permissions, you’ll see immediately that a new file called TSXCACHE.BIN will be created in the directory.
Enjoy,
Roni Vered Adar.
