问题描述
我创建了一个数据库脚本步骤，该脚本可以访问Workload Scheduler Service中的SQL Database Service.当我运行该过程时，该步骤遇到以下错误.
I create a step of database script which access to SQL Database Service in Workload Scheduler Service. When I run the process, the step encountered the error below.
错误消息
说明
作业无法访问JDBC驱动程序文件夹，您可能无法访问 有足够的权限. 系统操作
不执行该操作.
操作员的反应
验证您是否具有足够的权限.
Explanation
The job was not able to access a JDBC Driver folder, you might not have enough permissions. System action
The operation is not performed.
Operator response
Verify that you have enough permissions.
此消息似乎是要我授予工作用户适当的权限.但是没有属性可以指定Workload Automation Agent的作业用户.我使用由Bluemix自动配置的Workload Automation代理.
This message seems to ask me to grant the proper authority to the job user. But there is no property to specify the job user of Workload Automation Agent. I use a Workload Automation Agent provisioned by Bluemix automatically.
您能教我需要哪些参数吗?
Could you teach me which parameters are needed ?
数据库脚本步骤信息
JDBC驱动程序类路径信息
我通过以下"ls -lR"命令步骤的日志检查了路径.
JDBC driver class path info
I checked the path by the following "ls -lR" command step's log.
推荐答案
代理似乎有问题，我试图复制相同的作业类型，但是它无法处理相同的错误消息(即使使用不同的解决方案也是如此)用于jdbc驱动程序路径).如果您使用的是为您创建的Workload Automation代理，则可以打开支持通知单，以使Workload团队查看该代理.
it seems to have a problem with the agent, I tried to replicate the same job type but it is not working with the same error message (even using different solutions for jdbc driver path).If you are using the Workload Automation Agent that is created for you then you could open a support ticket to have the Workload team look at that agent.
在服务团队的支持下进行
Edit after having support from service team:
在预定义的工作负载调度程序过程的jar类路径字段中，您只需要放置包含jar文件的目录的路径，而不必使用jar文件名.
in the jar classpath field for a predefined workload scheduler process you have to put only the path to the directory containing jar files, without putting the jar file name to use.
因此，根据当前的Workload Scheduler文档，您必须使用以下值:/home/wauser/utils
So, according to current Workload Scheduler documentation, you have to use the following value:/home/wauser/utils
通过这种方式，数据库脚本可以正常工作.(已添加屏幕截图)
By this way the database script works fine.(screenshot added)
这篇关于遇到数据库脚本"AWKDBE018E无法访问所需的JDBC驱动程序文件夹".在Workload Scheduler中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！