Troubleshooting
Problem
When attempting to execute a SQL Server Job with a trigger.bat call, an error message is returned.
Could not find or load main class Trigger
Symptom
Error being returned.
Cause
The SQL Server Job was calling the trigger.bat, however, it was not running the batch file from the directory structure that contained the Trigger.class file.
Environment
Windows
Resolving The Problem
Modify the Trigger.bat file so that when the SQL Server Job executes it, it changes directory to where the Trigger.class file resides.
For example, if the trigger.bat/class file exists in the C:\Trigger directory:
cd C:\Trigger
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
09 July 2019
UID
ibm10958805