Dear Sir/Madam,

I am very strange for the automatically job to run a sql report, it's always failed.
First, I have created a sql report to query receipt table:tdpur045.
Then,from the exute query I make a job to do this report, because this session belong to 000 company, then i only can find the job when i change to 000 company.
When I use another user login system(default company 000)and run the job, it's always run.

How can i set the job to run the excute report?


Thank
Best regards

Charly Zhuo

Hi,

We use a lot of queries in jobs.
To set the job, we use ttadv3180 and make job.

The job is in company 000 but works on the company you are logged on when you set the job.

Regards