Running TIBCO Scribe Insight DTS Files Using Windows Task Scheduler

Running TIBCO Scribe Insight DTS Files Using Windows Task Scheduler

book

Article ID: KB0073062

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

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. 

Issue/Introduction

This article describes how to use Windows Task Scheduler to run DTS files as an alternative to using an Integration Process in the TIBCO Scribe Insight Console.

Resolution

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.
 

Screenshots

Windows Task Scheduler open


Data Migration folder created
User-added image

Data Migration folder Open


Creating Basic Task


Task Trigger




Action


Enter or browse to the executable file or script you want to run






In the Summary dialog, select Open the Properties dialog for this task when I click Finish and then click Finish. The Maintenance Manager Properties dialog opens.


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.
- Select Run whether user is logged on or not.
- Select Run with highest privileges option.

User-added image

Ensure that the Maintenance Manager domain/Windows account is correct, enter the password, then click OK
User-added image

The task has been successfully setup
User-added image

Records in Source
User-added image


No records in the Target
User-added image

Running the task from Windows Task Scheduler
User-added image

Task completed successfully
User-added image

Records successfully migrated to the SQL Target
User-added image

Timestamp in Scribe Execution log showing DTS ran successfully