gv wrote:
> AHHH. Thanks You!!!
>
> That query is exactly what I was looking for. It says
> TimedSubscription and gives me the report name.
>
> I think I would like to change it to Shared Schedules
>
> thanks again
> gv
>
> "Devin" <dlosee@granitelp.com> wrote in message
> news:1161285823.236151.182020@m7g2000cwm.googlegroups.com...
> >I always prefer to use shared jobs because they are much easier to
> > change (as long as you have standard reports which are run
> > daily/weekly/monthly/etc). Here's how you set up a shared schedule:
> > - Click "Site Settings" at the top right of Report Manager
> > - Click "Manage Shared Schedules" on the bottom left
> > - From here you can add/change/delete shared jobs
> > - If you see none then obviously you are not using scheduled jobs
> >
> > Since you said you were the dba, I assume you have access to the
> > database ReportServer. Run this query, and it should tell you the
> > basic info:
> >
> > SELECT S.ScheduleID, S.[Name] AS ScheduleName, S.NextRunTime,
> > S.LastRunTime,
> > S.EventType, C.[Path], C.[Name] AS ReportName
> > FROM [schedule] S
> > INNER JOIN [ReportSchedule] R ON S.ScheduleID = R.ScheduleID
> > INNER JOIN [Catalog] C ON R.ReportID = C.ItemID;
> >
> > You can match up the ScheduleID with the ID you see in the Agent. If
> > you have a lot of reports, you can even put it in the where clause
> > (S.ScheduleID = SQL_AGENT_ID). If EventType is "SharedSchedule" then
> > you are using shared schedules, so the change should just be in 1 place
> > (unless multiple jobs are failing). If it says "TimedSubscription"
> > then you will have to go into each report's properties and change the
> > subscription. Hope this helps.
> >
> > Devin
> >
> >
> > gv wrote:
> >> Thanks alot for your help, I'm very new to Report Server and new as a
> >> DBA.
> >>
> >> No, it is ReportServer. Yes, many run fine.
> >> I think they are setup individually. Not sure. How would I check?
> >>
> >> In the Agent it doesn't say what report? Just has a long number.
> >>
> >> When you goto properties in the first tab page in box says this:
> >>
> >> "This is a Reporting Services job. Modifying this job could result in
> >> database incomptabilities.
> >> Please use the Report Server UI to update this job."
> >>
> >> I'm confused on how to research scheduled jobs in Report Server and make
> >> changes?
> >> Other people have created these. At first looking at the error.
> >> I noticed the name of the database had SQL at the beginning of it instead
> >> of just saying ReportServer. I think this is the problem. But how
> >> do I change it? Goes back to first knowing what Report. How?
> >> How do I relate the long number in SQL agent to a report name in Report
> >> Manger?
> >>
> >> thanks again for your help
> >> gv
> >>
> >> "Devin" <dlosee@granitelp.com> wrote in message
> >> news:1161282924.264914.265360@i3g2000cwc.googlegroups.com...
> >> > Is SQLReportServer the name of the database? The default is just
> >> > ReportServer. Do any scheduled reports run successfully? Do you have
> >> > it setup as shared schedules or are they individually scheduled per
> >> > report?
> >> >
> >> > You can probably tell which report(s) are failing by looking at the
> >> > scheduled date/time within SQL Agent and then matching it up with the
> >> > scheduled report(s) in Report Manager that run at that time.
> >> >
> >> > It sounds like 1 more schedules are corrupt. I would check all the
> >> > scheduled jobs (in SQL Agent) and make sure that each is pointed to the
> >> > correct database. If they all are, then you may want to delete and
> >> > re-create the scheduled jobs that are erroring (assuming you don't have
> >> > that many).
> >> >
> >> > Devin
> >> >
> >> > gv wrote:
> >> >> I did, I see nothing there.
> >> >>
> >> >> I got this message from Agent job history
> >> >>
> >> >> thanks
> >> >> gv
> >> >>
> >> >>
> >> >> "Devin" <dlosee@granitelp.com> wrote in message
> >> >> news:1161275847.753301.134330@i3g2000cwc.googlegroups.com...
> >> >> > Did you check the log files (or is that where this error came from)
> >> >> > located in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> >> >> > Services\LogFiles\?
> >> >> >
> >> >> > Devin
> >> >> >
> >> >> > gv wrote:
> >> >> >> Hi all,
> >> >> >>
> >> >> >> I'm getting failed Report Server jobs. How do I find out what
> >> >> >> report
> >> >> >> it
> >> >> >> is,
> >> >> >> user and, more information?
> >> >> >>
> >> >> >> The only information I see is a Step Name which is a long number
> >> >> >> and
> >> >> >> then
> >> >> >> a
> >> >> >> message that says this:
> >> >> >>
> >> >> >> "Executed as user: MyDomain\AdminPass. Could not locate entry
> >> >> >> in sysdatabases for database 'SQLReportServer'. No entry found
> >> >> >> with that name. Make sure that the name is entered correctly.
> >> >> >> [SQLSTATE 08004] [Error 911]. The step failed.
> >> >> >>
> >> >> >> thanks
> >> >> >> gv
> >> >> >
> >> >
> >