I have a stored procedure which will pick MQ files from receive location, process it and drop it in save location.
Currently, this stored procedure is not working when I execute it manually.
But files are picked up and saved in the save location automatically at a particular time of day daily. I don't know which stored procedure is calling for this.
There is a SQL Server job which is set up daily at this particular time. This job is calling the same stored procedure which i call manually.
When i try to run the SQL job manually the files are not picked up.
Could you please help; will be there any mechanism in MQ to pick the files and drop it in receive location?