Changing report schedule according to job completion

I have about 30 reports currently being refreshed every morning at 7:30. The
problem is that the reports should only be refreshed once the data load is
complete.
I checked the ReportServer database and noticed that the schedule is stored
on the Schedule table. Could I just update the StartDate and NextRunTime
columns to make the schedule refresh the reports when I want it (after the
data load is finished)?
Thanks in advance for any help,
Carmen.I have never tried it, but what would it hurt to try?... GO ahead... backup
stuff first..who knows what might happen...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Carmen" wrote:
> I have about 30 reports currently being refreshed every morning at 7:30. The
> problem is that the reports should only be refreshed once the data load is
> complete.
> I checked the ReportServer database and noticed that the schedule is stored
> on the Schedule table. Could I just update the StartDate and NextRunTime
> columns to make the schedule refresh the reports when I want it (after the
> data load is finished)?
> Thanks in advance for any help,
> Carmen.