A quick solution for SQL server scheduled job calling Kettle job errors. kettlejob

A quick solution for SQL server scheduled job calling Kettle job errors. kettlejob

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 ': cocould not find file with URI "C: \ Windows \ system32 \ config \ systemprofile \. kettle \ plugins "because it is a relative path, and no base URI was provided. unable to get VFS File object for filename 'C :\ Windows \ system32 \ config \ systemprofile \. kettle \ plugins ': cocould 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 .. This step is successful.

Cause:

The default configuration files generated by kettle are stored in C: \ Users \ Administrator \. kettle. The system32 Administrator permission is used for running the SQL Agent.

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 error of the Kettle job called by the SQL server scheduled job described in the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in time!