April 8, 2019 at 2:28 pm
Unfortunately the SQL server does not give any value in the column NextRunTime
So can anyone provide the logic how to calculate the NextRunTime columns value.
USE ReportServer
GO
-----------------------------------------------------
WITH getScheduleInfo AS
(
SELECT
ReportName = CAT.[Name]
,ReportPath = CAT.[Path]
,SCH.RecurrenceType
,SCH.MinutesInterval
,SCH.DaysInterval
,SCH.WeeksInterval
,SCH.DaysOfWeek
,SCH.DaysOfMonth
,SCH.Month
,SCH.MonthlyWeek
,SCH.State
,SCH.NextRunTime
FROM dbo.Subscriptions AS SUB
INNER JOIN dbo.Users AS USR
ON SUB.OwnerID = USR.UserID
INNER JOIN dbo.[Catalog] AS CAT
ON SUB.Report_OID = CAT.ItemID
INNER JOIN dbo.ReportSchedule AS RS
ON SUB.Report_OID = RS.ReportID
AND SUB.SubscriptionID = RS.SubscriptionID
INNER JOIN dbo.Schedule AS SCH
ON RS.ScheduleID = SCH.ScheduleID
)
SELECT *
FROM getScheduleInfo
ORDER BY 1,2
April 9, 2019 at 5:23 pm
You need to join sysjobs and sysjobschedules and then get the next run date/time from sysjobschedules.
Sue
April 9, 2019 at 5:54 pm
Thanks,
Also I noticed the interface has changed. Can you help me with the editor. what set of tags should I use for displaying code ?
it used to be but it did not create a nice frame around the code. Is there another set of tags that I need to use. Please help
April 9, 2019 at 6:04 pm
The web site was been updated and they are working through the issues from all of the changes, data migration, etc.
I'm having issues with the code tags as well - the editor has the buttons like we used to have with the old site but it's not showing up for everyone. Trying to do it manually doesn't work well. Take a look at this thread and see if you have the same toolbar with the codes like we used to have - Steve posted a screenshot of what his looks like:
I'm guessing you might be hitting the same thing and not seeing it - they'll get it fixed.
I've been just pasting everything for now.
Sue
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy