selecting top 100 rows in query

[Former Member]

Hi All,

I got stuck in writing query to fetch 100 records at a time.

Here is what I have tried.

select JobDefinition.* from JobDefinition LIMIT 100

select Top 100 JobDefinition.* from JobDefinition

select JobDefinition.* from JobDefinition FETCH FIRST 100 ROWS ONLY

All the above queries ended with sql exception.

Any pointers are really helpful.

[nanda_kumar21]

what exception are you getting?

[Former Member]

Hi Nanda,

standard persist error is coming for all the queries I have tried. The main idea is to update keepclause for 100 jobs at once. However, I did the same in shell  directly by giving names.

I have another doubt here.

difference between Job and HistoryJob.

When I updated jobs with keepclause, the size of HistoryJob table decreased but not the Job table.

However when randomly checked a couple of jobs, I could see the job instances according to keepclause in Job monitor.

I am confused here whether cleaning up Job table is possible or not. The reason is we are getting connection timeout when we click Job Monitor and we thought deleting old jobs might solve the issue.

We have set the ICM connection time out as 600 secs.

Pointers pls