Error

[5vrajasekaran]

Hi,

When I was trying to SFTP a file from one location to other am getting the following error

 FTP JOB Completed Abnormal : Could not find file abc.txt.

But I haven't given abc.txt file to transfer in this job setup,but there are some other setup in my scheduler which transfer the mentioned file in the same location.

Can someone help me or provide the reason why Am getting this kind of error.

[Derrick Au]

Hi 5vrajasekaran,

The FTP job created, was this copied from an existing FTP job? or is a new FTP job creation?

Please run the following query: SELECT * FROM jobmst WHERE jobmst_type = 6

This will list out all FTP jobs in your environment, but you can add additional where clauses to narrow down your search.

BR,

Derrick Au

[5vrajasekaran]

Hi Derrick,

Where should I run this query?

[Derrick Au]

Hi 5vrajasekaran,

You can execute this query against the Admiral database using SSMS (SQL Server Management Studio), or have your SQL DBAs run this query.

BR,

Derrick Au