cancel
Showing results for 
Search instead for 
Did you mean: 

The IDM 8.0 jobs seem to go off by itself

Former Member
0 Kudos

Hi, all

I have just upgraded our IDM sandbox from 7.2 to 8.0. When testing some of the existing jobs, I noticed that a lot of them are running unexpectedly. They are on-demand jobs and I disabled them. So in theory, they can only be triggered by myself clicking on the run button.

When these jobs go off by themselves, I noticed that they are "enabled", but not my myself. Have you seen this behavior? Is there a way to see the "whole" job queue including the ones that have not run yet, but in the queue in IDM, sort of like the SM37 in the ABAP systems?

By the way, there is a scheduled time that got populated to a future date in those jobs that fired off automatically.

Thanks,

Jonathan.

Accepted Solutions (1)

Accepted Solutions (1)

jaisuryan
Active Contributor
0 Kudos

Hi Jonathan,

select * from mc_jobs with (nolock) where ScheduledTime > GETDATE()

Above SQL (MS SQL) statement would give the list of jobs that are scheduled to run in future. But not sure if they will run even if they are disabled.

Kind regards,

Jai

Former Member
0 Kudos

Thanks, Jai

Which column is the id of the job? The jobid I try to search is not found. We are running on oracle, so I guess the query will be:

select * from mc_jobs where scheduledtime > sysdate

jaisuryan
Active Contributor
0 Kudos

Hi Jonathan,

The column "JobId" has the job ids of the jobs. Is the job still getting triggered?

Can you check the rule properties of "On Demand" and post the screenshot?

Also, please get it raised to SAP so that they can investigate if its product bug.

Kind regards,

Jai

Former Member
0 Kudos

Hi, Jai

No, they are stopped now. The problem seems to be that after the upgrade, all the "on demand" jobs become "enabled" and automatically put into schedule every 30 minutes. Here is what I see:

Even if I remove the "enabled" check, they still run and probably because they are "scheduled" for the future. I noticed that manually "stopping" them while they are running will permanently stop them. It is too bad IDM still doesn't have any basic job maintenance tool like SM37.

I have already logged a ticket with SAP support 3 weeks ago and still nobody picked up the ticket. The IDM support is ridiculous. Overall, my impression with IDM 8.0 is that the majority of changes is superficial. There is no major functionality change that makes the product any better than 7.2. The eclipse interface is slower and tougher to work on compared to the old MMC interface. It is rather disappointing. A version like IDM 7.2.1 is more appropriate.

Thanks,

Jonathan.

Answers (0)