echo "Starting Windows Task Scheduler - Batch File"
dtexec.exe /DTS "\"\MSDB\Load_FBDFiles_v01_13072016\"" /SERVER "\".\"" /CHECKPOINTING OFF /REPORTING V
echo "Completing Windows Task Scheduler - Batch File"
The batch file can be called from an automated windows task
Here’s how to get
there:
- Open the Control Panel.
- Open the Administrative Tools window.
- In Windows 7, look under System and Security(Windows Vista, under System and Maintenance)
- Open the Task Scheduler icon.
- If prompted, type the administrator’s password or click Continue.
- The Task Scheduler window appears.
- Create new Task & Schedule ‘Load FBD Files Monthly’ accordingly, point task towards the following script “Load_FDB_Batch_WinTScheduler.bat” Ensure the task is set to run with the highest privileges. Set the schedule to desired frequency. The task should also be set to “Run whether user is logged in or not” and “Do not store password” should be checked.
No comments:
Post a Comment