Products | Versions |
---|---|
TIBCO Scribe Insight | - |
There have been some cases in the past where customers get random errors running Timed-based integrations using the Scribe Console with all user permissions setup correctly but the same DTS runs and processes records successfully via the TIBCO Scribe Workbench without any errors. To workaround this issue, Support recommends using the Windows Task Scheduler which allows users to create automated tasks to be run by Windows at specific time intervals.
This guide explains how to schedule a basic task using the Task Scheduler.
Steps (Please work with your IT admin):
There are a few ways to run a DTS via Windows task scheduler:
1. Using a batch file
2. Selecting the program (Tworkbench) and adding arguments which would be the location of the dts file.
Using a batch file
1. Create a batch file to lunch the DTS and use the command line switch (/RS) to run each job in Silent mode, preventing any screen messages from blocking processing. Example below:
"C:\Program Files (x86)\Scribe\
Tworkbench "C:\Users\Public\Documents\Scribe\Collaborations\SQLDataMigration.dts" /RS"
--Command Line Switches--
https://help.scribesoft.com/scribeinsight/en/Subsystems/Insight/runningjob/command_line_switches.htm
2. From the Start menu, select Administrative Tools > Task Scheduler.
3. Under Task Scheduler (Local), select Task Scheduler Library and choose New Folder from the Actions panel.
4. Enter Data Migration (or any name) and click OK. The new folder is created for your Data Migration scheduled tasks.
5. Expand Task Scheduler Library and select the Data Migration folder.
6. In the Actions panel, click Create Basic Task.
7. In the Create a Basic Task dialog, enter a name for the task and click Next.
8. In the Task Trigger dialog, select Daily and click Next.
9. In the Daily dialog, enter the Start date and time, and click Next.
10. In the Action dialog, select Start a program and click Next.
11. In the Program/script field, browse and select the batch file, then click Open.
If you are using the other method by selecting the program, then browse and select the Tworkbench executable "C:\Program Files (x86)\Scribe\Tworkbench from the Scribe folder and enter the location of the dts
"C:\Users\Public\Documents\Scribe\Collaborations\SQLDataMigration.dts" /RS" in the Add argument field.
12. Click Next.
13. In the Summary dialog, select Open the Properties dialog for this task when I click Finish and then click Finish. TheMaintenance Manager Properties dialog opens.
14. If the Properties window for the Maintenance Manager task is not already open, double-click the task name in the Task Scheduler Library. The Properties window opens with the General tab displayed.
15. Under Security Options, identify the domain/Windows account currently associated with the task. If it is not the correct account, click Change User or Group and select the Maintenance Manager domain/Windows account.
16. Select Run whether user is logged on or not.
17. Select Run with highest privileges option.
18. Click OK.
19. Ensure that the Maintenance Manager domain/Windows account is correct, enter the password, then click OK.
20. Click OK to close the Properties window.
21. Close the Task Scheduler.
Data Migration folder Open