Share
Report
4Greetings,
While troubleshooting a Mekorma/payroll printing freeze up, I found the following in the running on SQL in the activity monitor. It appears that it's looking for some Manufacturing scheduled reports. We have no reports set up in the scheduler within GP. I tested this with a few other users and see that this occurs shortly after the user logs into GP.
Any ideas? Thanks in advance!
Here's the script found in the SQL Session:
SELECT TOP 25 RPTGRIND,PRODID,RTPACHIN,RTCFGWIN,RTGRSBIN,RPTGRNMS,Business_Desk_Report_Nam,Business_Desk_Report_Typ,Report_URL,Publish_Frequency,STRTDATE,STRTTIME,NMBROFDYS,DailyFrequencyOptions,WeeklyFrequencyOptions,MonthlyFrequencyOptions,ScheduledDaysOfTheWeek_1,ScheduledDaysOfTheWeek_2,ScheduledDaysOfTheWeek_3,ScheduledDaysOfTheWeek_4,ScheduledDaysOfTheWeek_5,ScheduledDaysOfTheWeek_6,ScheduledDaysOfTheWeek_7,ScheduledDayOfTheWeek,Scheduled_Week_Of_The_Mo,DAYOFMONTH,ScheduledMonthOfTheYear_1,ScheduledMonthOfTheYear_2,ScheduledMonthOfTheYear_3,ScheduledMonthOfTheYear_4,ScheduledMonthOfTheYear_5,ScheduledMonthOfTheYear_6,ScheduledMonthOfTheYear_7,ScheduledMonthOfTheYear_8,ScheduledMonthOfTheYear_9,ScheduledMonthOfTheYear_10,ScheduledMonthOfTheYear_11,ScheduledMonthOfTheYear_12,Number_Of_Weeks,Last_Date_Published,Last_Time_Published,Next_Day_To_Publish,Next_Time_To_Publish,GenerateReportScript,OpenReportOptionWindowSc,Keep_Prior_Versions,DEX_ROW_ID FROM GL.dbo.ReportSchedule WHERE (PRODID=346) ORDER BY RPTGRIND ASC ,RTPACHIN ASC ,RTCFGWIN ASC ,RTGRSBIN ASC ,PRODID ASC
*This post is locked for comments
All responses (
Answers (
