A quick solution to the problem of calling the key job by SQL Server scheduled job

Time:2019-12-21

Error message:

Unable to list jar files in plugin folder ‘C:\Windows\system32\config\systemprofile\.kettle\plugins’ Unable to get VFS File object for filename ‘C:\Windows\system32\config\systemprofile\.kettle\plugins’ : Could not find file with URI “C:\Windows\system32\config\systemprofile\.kettle\plugins” because it is a relative path, and no base URI was provi Ded. Unable to get VFS file object for filename ‘C: \ windows \ system32 \ config \ systemprofile \. Kettle \ plugins’: could not find file with URI “C: \ windows \ system32 \ config \ systemprofile \. Kettle \ plugins” because it is a relative path, and no base URI was provided. At org. Pentaho. Di. Cor… process exit code 0. . the step succeeded.

Cause of the problem:

The default configuration files generated by kettle are stored under C: \ users \ administrator \. Kettle, and the SQL agent runs with system32 administrator privileges

Solution:

Find the. Kettle folder under C: \ users \ administrator and copy it to C: \ windows \ system32 \ config \ systemprofile. If the target file already exists, replace it directly

The above is a quick solution to the problem of SQL Server timing job calling kettle job introduced by Xiaobian. I hope it can help you. If you have any questions, please leave me a message, and Xiaobian will reply you in time!