I created a job to call a Baan SQL every 2 months, the job lists no sessions by job, however, if I print the job data I can see the session linked to the job.

Has anyone come acros a similar in the past when trying to print SQL's from a job?

Cheers

Could you be more specific? :( :confused:

You want to run a job every 2 months to monitor the use of queries?

Remember jobs in the tools sessions are stored in the tools tables of company 000. Also SQL queries run on tools tables are stored in the tools company 000.

But the application tables that are used for SQL queries are stored in the application companies 001-999, and in my opinion you should create a SQL query that not only runs trhough the tools company but through all application companies also.

Maybe the above information already lightens your question.