Transformation Won't Run from Schedule

More
1 week 3 days ago #26298 by ssmith
This is all new for us. Have Advanced ETL Processor Enterprise (32bit) running on Windows 11. Developed a simple test Transformation which runs fine on demand from the designer (via green "Run" arrow button). Set it up in the Schedule, and it runs fine on demand from there as well (via the blue "Run Now" arrow button). Both log the execution in the 'Execution Log' tab. But we simply cannot get it to run on schedule. And there is absolutely no evidence that we can find that Advanced ETL is even attempting to execute it automatically.

On the entry's 'Schedule Options' dialog in the 'Task' tab, have both 'Enabled' and 'Use Agent for Execution' checked. Have tried "Windows (32-bit)," "Windows (64-bit)" and blank for 'Application Platform' with no success.

Have the 'ETL Server - Execution Agent (32bit)' service Running.

We must be overlooking something.

Is there a detailed guide for setting up Advanced ETL to run jobs via its scheduler?

 

Please Log in or Create an account to join the conversation.

More
1 week 3 days ago #26299 by admin
Hi and welcome to the forum

The agent runs sql against the repository to check if there is anything to execute.

If you use SQL Server as repository you can see the actual sql using profiler

in case of sql server repository you have to set user language to english otherwise it will not work
Here is how
www.etl-tools.com/wiki/knowledgebase/rep...l-server-repository/
   
Also read this article
www.etl-tools.com/wiki/knowledgebase/tip...rstanding-scheduler/
 
If this does not help post some scrreshots

Please keep us updated on your progress

 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 week 3 days ago #26301 by ssmith
Based on the article  www.etl-tools.com/wiki/knowledgebase/tip...rstanding-scheduler/  I checked 'Enabled' for the "AETLAGENT32" entry in the 'Maintain' page, and the Transformation now gets executed by the Scheduler. Thank you! I can confirm the execution based on the contents of the "Package" and "Transformation" files that were created in the Log folder, as well as the fact that the expected output file was created.

But I can't find any evidence within the Advanced ETL User Interface itself that confirms that the Transformation was executed. When I look at the 'Execution Log' page, all I see are the entries for the successful manual invocations that I performed previously. Shouldn't the executions carried out by the scheduler show there as well?

 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 week 2 days ago #26302 by admin

Please Log in or Create an account to join the conversation.

More
1 week 2 days ago #26303 by ssmith
Thanks again. I had been clicking 'Refresh.'
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save