Tag Archives: Troubleshooting

Errors in SQLAGENT.OUT log – Unable to open or read TSX cache file

14 Mar

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

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.