Toad World® Forums

scheduled report not creating file


#1

I’ve run a script and tested successfully using the “TEST” button. The process run and the file gets exported to the correct location. I go to “SCHEDULE”, setup a one time run and it apprear that everthing works correctly, but not file get’s put out to the location specified in the .tas automation file. I’ve attached a screen shot of the Scheduled run.

Thanks!

scheduled report problem.jpg


#2

Turn logging to verbose and add any comment activities that would show progress through the script. At end of script attached log file to an email activity and send to yourself. This will give you the details of what happens during the scheduled execution.

Debbie


#3

This is the log I’m getting:

– 1/15/2010 2:31:05 PM: Script_1_ELECTRO_COMPONENTS.log: Build started
– 1/15/2010 2:31:07 PM: Script_1_ELECTRO_COMPONENTS.log: Build Completed
– 1/15/2010 2:31:08 PM: Script_1_ELECTRO_COMPONENTS.log: Executing default description activity
– 1/15/2010 2:31:08 PM: Script_1_ELECTRO_COMPONENTS.log: Connecting to PROD (MINC1APP), MINC1APP
– 1/15/2010 2:31:09 PM: Script_1_ELECTRO_COMPONENTS.log: Connection failed.
– 1/15/2010 2:31:09 PM: Script_1_ELECTRO_COMPONENTS.log: Done

I can see it’s not connecting. Is this a different connection that when you click the “test” button, because that works fine?

Thanks,
Tom


#4

When you are in the app testing you usually are already connected. Try going to the app and run the script in TDA with the connection close. This will force it to connect in the application. You may see the issue here.

Does this connection have a saved password? Unless this is an OS Authentication connection you will need to save your password in your connection file. Also, when in the designer, double click on the yellow connection activity and confirm that you have the correct connection selected.

Debbie