Windows Scheduling iSeries Data Transfer

pts.
Tags:
AS/400
DB2 Universal Database
Desktops
Management
Microsoft Windows
OS
PC/Windows Connectivity
Security
Servers
Software
SQL
SQL Server
Tech support
Web development
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. AND Invalid file type. It is either not a transfer file request type, or the file has been corrupted. Any help would be appreciated. Thanks Heather

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’m probing the deep dark recesses of my increasingly feeble memory, but if it serves me, I think the Windows job scheduler will only run .bat .cmd files.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Heather400
    Windows scheduler can do more than just .cmd and .bat files. I have it running the data transfer program it just won't run the specfic btf files
    0 pointsBadges:
    report
  • CarterC19
    I think you can include Client Access transfers in a .bat file with the rtopcb command, yes? Need to have the client access directory in the path, I'd bet, but I think using the rtopcb command and then pass it the .dtf file name will actually run the thing. Sort of like rtopcb c:mytransfer.dtf
    220 pointsBadges:
    report
  • Heather400
    rtopcb command didn't work but I googled it and found another similar command (rxferpcb) that will run in an unattended environment with username and password. It works great! Thanks so much for putting me on the right track.
    0 pointsBadges:
    report
  • IdratherBEFishing
    Glad to hear you found a solution. I thought I'd offer an alternative that allows control from the AS400 instead of the Windows job scheduler. This way you'll have the messages from the PC and have a way to check from the AS400 as to whether the process ran sucessfully. Included in Client Access is the Run Remote Command service. AS the administrator of the PC or a MS server you can set this service to run automatically when the PC or server is booted. You can use a user-id at the PC or server that has access to the directories where the data is stored or you can create a user on the PC or server just for this purpose that only has access to the necessary data and directories. Once you have the file transfers working such that they work under the user-id you intend to use by only double clicking them, you should be able to put the executables in a bat file. If when you ececute the bat file under the user-id you've set up and all is well you are ready for the next step. You simply create a CL on the AS400 and use the run remote command to call the bat file on the PC or server. There is much more information about using the Run Remote Command at the I-Series information center on the web. I like using this method because there is a lot information the AS400 gives me about what occurred at he PC or server level and I can use the AS400 Job scheduler to control when the process is run. In addition, I can build upon the CL to have other processes on the AS400 take place after a sucessful transfer of data. Just another way to accomplish the same goal.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following