Toad Data Compare Tasks getting hung on Scheduled Runs

Toad for SQL Server
1

I’m running into issues while running the data compare job in the automation task. It runs for hours apparently with no activity. it runs fine some days but not always.

I’m able to run the task manually using the Toad and execute the task and it runs just under 30 minutes.

  • Ran the automation task by setting it in verbose mode.

  • Automation task execute sql statement before running the compare job. It then uses the value from the sql statment and send e-mail.

  • Attached is the log

– 11/28/2017 11:38:27 AM: MyTask_Task.log: Setting up environment
– 11/28/2017 11:38:27 AM: MyTask_Task.log: Script run by Toad for SQL Server 6.8.0.97 as <> on Server
– 11/28/2017 11:38:27 AM: MyTask_Task.log: Build started
– 11/28/2017 11:38:27 AM: MyTask_Task.log: Compiling script
– 11/28/2017 11:38:27 AM: MyTask_Task.log: Start CompileWorkflow
– 11/28/2017 11:38:27 AM: MyTask_Task.log: Before Compile
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Return from CompileWorkflow
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Workflow Compiled without Errors
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Build completed
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Create Workflow instance
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Started workflow instance
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Begin execution script activities
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Variable “ROOT_PATH” set to ‘’
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Scanning the script for prompt bind variables
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Connection description = <<my sql server??(<><>), <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Connection node found
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Connection to: dsciscsrs (<><>), <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Connection successful
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Connection logon:
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Last schema: <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Default schema: <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Auto Commit: True
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Executing script: SELECT * FROM <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Executed: SELECT * FROM <>
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Query returned 1 rows
– 11/28/2017 11:38:28 AM: MyTask_Task.log: Script execution completed.