Report of all jobs that are scheduled

[cazzafed]

Hello,
In advance, sorry for my bad English.

Is there a report that lists all the reports that are scheduled to run?
We had a problem where the executions were stopped and we want to try to find out which reports should have been executed....
Regards...

 

[DSauve]

On a Windows client, go into P91300. There is a form exit to show all scheduled jobs, including the job status.

 

[MFreitag]

Here's something we came up with years ago to use in a BI Publisher Report. This was done on SQL Server, edit appropriately. Maybe you can find something useful in this SQL.

select
  rtrim(SJSCHJBNM) as Job_Name
  ,rtrim(SJSCHRPTNM) as Report_Name
  ,rtrim(SJSCHVER) as Report_Version
  ,rtrim(SIMD) as Report_Desc
  ,rtrim(SISY) as System_Code
  ,rtrim(VRJD) as Version_Desc
  ,rtrim(SJSCHJBSTAT) as Job_State
  ,rtrim(SJSCHUSER) as Schedule_User
  ,rtrim(SJJOBQUE) as Job_Queue
  ,rtrim(DRDL01) Schedule_Type
  ,dateadd(s,((SD2.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01') as Execution_Next_to_last
  ,dateadd(s,((SD1.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01') as Last_Execution
  ,datediff
    (mi,dateadd(s,((SD2.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01'),dateadd(s,((SD1.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01')
  ) as Diff_in_Min
  ,datediff
    (hh,dateadd(s,((SD2.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01'),dateadd(s,((SD1.JSSCHSTTIME + (datediff(hh,getutcdate(),getdate()) * 60)) * 60),'1970-01-01')
  ) as Diff_in_Hours
from
  JDE920.SY920.F91300
left join
  JDE_PRODUCTION.PRODCTL.F0005
on
 SJSCHRCRTYP = ltrim(rtrim(DRKY))
 and DRSY = 'H91'
 and DRRT = 'RC'
left join
  JDE_PD920.PD920.F983051
on
  SJSCHRPTNM = VRPID
  and SJSCHVER = VRVERS
left join
  JDE920.OL920.F9860
on
  SJSCHRPTNM = SIOBNM
outer apply
  (select top 1 JSSCHSTTIME from JDE920.SY920.F91320 where SJSCHJBNM = JSSCHJBNM order by JSJOBNBR desc)
as SD1
outer apply
  (select top 1 * from (select top 2 JSSCHSTTIME,JSJOBNBR from JDE920.SY920.F91320 where SJSCHJBNM = JSSCHJBNM order by JSJOBNBR desc) as A order by JSJOBNBR asc)
as SD2
where
  SJSCHJBTYP = '01'
order by
  SJSCHRPTNM asc
  ,SJSCHVER asc
;

 

[cazzafed]

Hi, sorry.
I mean the BIP reports that are scheduled to run ('Report Job' in BIP). Is there something for that?

 

[StewartSchatz]

Here is something that was put together years ago, but I think it should still work: http://e1tips.com/2013/06/21/an-enterpriseone-scheduler-report-you-can-give-a-user-using-sql/