A quick workaround for SQL Server timed jobs to invoke kettle job errors _mssql

Error message:

Unable to list jar files into plugin folder ' C:\Windows\system32\config\systemprofile\.kettle\plugins ' unable to get VFS-Fil e object for filename ' C:\Windows\system32\config\systemprofile\.kettle\plugins ': Could not find file with URI C:\Window S\system32\config\systemprofile\.kettle\plugins "because it is a relative path, and no base URI was provided. Unable to get VFS the File object for filename ' C:\Windows\system32\config\systemprofile\.kettle\plugins ': Could isn't find Fil E with URI "C:\Windows\system32\config\systemprofile\.kettle\plugins" because it are a relative path, and no base URI was p Rovided. At Org.pentaho.di.cor ... Process exit code 0. This step is successful.

Problem Reason:

Kettle the various configuration files generated by default are stored under C:\Users\Administrator\.kettle, and the SQL Agent runs with System32 administrator rights

Solution:

Locate the. Kettle folder under C:\Users\Administrator, copy to C:\Windows\system32\config\systemprofile below, and replace it if the target file already exists

The above is a small set to introduce SQL Server timed job call Kettle Job Error quick solution, hope to help everyone, if you have any questions welcome to my message, small series will promptly reply to everyone!