Return
-
Title
How to migrate Windows Scheduled Toad automation task from one server to the next. -
Description
I scheduled many automation tasks in Toad on one server. How do I migrate these tasks to another server?
-
Resolution
1. In the source server, go to where your .tas and .tsm files are located.The .tas and .tsm are both located by default in C:\Documents and Settings\<user>\Local Settings\Application Data\Quest Software\Toad for Data Analysts 2.1\Toad Projects.Copy all the .tas and .tsm to destination folder located in the target server.2. In the source server, go to Control Panel | Scheduled Tasks in Windows.Copy and paste the scheduled tasks to the Scheduled Tasks folder of the target server.3. In the target server go to the Scheduled Task folder and open each of the tasks by double clicking and verify the following.a.Verify that the Run path is valid on the target server.It should point to where you have moved all your .tas files on the target server.Keep in mind the <user> of the target server as it may not be the same as the 1<sup>st</sup>server.Edit accordingly.b.Verify the Start in path is where TDA is installed in.Again, be mindful of the <user>.c.Change the password if the target server has a different password.4. On the TDA side, you have to verify two things.a.The .tsm files path is correct Open up .tas with Notepad and not TDA.Do a CTRL+F and search for .tsm.Verify that path is correct.For example…<ta1:SelectToExcelActivity x:Name=File_1 SqlScript=C:\Documents and Settings\<user>\Desktop\Test Space\myReport.tsm …b.The SMTP server information If the SMTP server has changed in the target server you need to correct that info.You can do it by opening .tas with note pad and look for the following line or open the .tas with TDA and edit via the GUI.For example…<ta0:SendEmailActivity From=emp@quest.com Authentication=Version=1,AuthenticationMethod=None Body=Test MapiServer=relay.quest.com To=emp@quest.com Subject=MyEmail x:Name=Email_1 Cc={x:Null} SmtpServer=SMTP.quest.com Description=Send email IncludeMessages=Log>…Note:It would worth while to open each .tas with TDA and run a test to make sure the imported .tas does run.If the test fails, redo step 4. -
Additional Information
You may need to have certain Windows privilege to copy and the Windows tasks in the Scheduled Tasks folder.