Scheduling SQL Server 2005 report server

I'm looking a way to schedule a report to be generated in pre-define time and push it out to my users through email or file share any format (excell, Word, etc). Any help would be greatly appreciated.

When you view the report in a browser you'll see four tabs - View, Properties, History, Subscriptions. Create a new subscription and then enter the recipient (actual email address required) and select the Render Format as Excel, PDF, Web Archive etc. You can also set the date, time and frequency of the subscription.

Hope this helps,

Aidan

Scheduled reports

I have set up reports to be generated hourly and emailed to me, however the report will run for a few hours and then stop. I have checked the schedule and made sure there is not expiration date. My question is: Is ther anyway is can get report status if the report errors with the error message so that i can track this issue?

Any assistance here would be greatly appreciated.

Regards,
Hi,
As far as I experienced there are few places where we can check the status of a scheduled report.
One of them is the reports' subscriptions tab ( http://reportserver/Reports/Pages/Report.aspx ) when you open the properties page for that report on the reports directory. There exists a status column.
Also when you edit the subscription for that report again on the same page above, you will be redirected to http://reportserver/Reports/Pages/SubscriptionProperties.aspx page. There is the schedule name which is used by the SQL Server instance where the ReportServer databases are installed.

If you go open Jobs list by using SQL Server Enterprise Manager, you can see the job in the list. Again detailed status information for that job can be seen there. Or by opening the job history screen from the context menu.
Or you can check the Event Viewer for the ReportServer service specific messages.
Eralper|||

Hi:

I set up a report that pulls data from the ExecutionLog table from the ReportServer DB.

If there is an error, it can be read from C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

Regs,

Perry

Scheduled reports

I have set up reports to be generated hourly and emailed to me, however the report will run for a few hours and then stop. I have checked the schedule and made sure there is not expiration date. My question is: Is ther anyway is can get report status if the report errors with the error message so that i can track this issue?

Any assistance here would be greatly appreciated.

Regards,
Hi,
As far as I experienced there are few places where we can check the status of a scheduled report.
One of them is the reports' subscriptions tab ( http://reportserver/Reports/Pages/Report.aspx ) when you open the properties page for that report on the reports directory. There exists a status column.
Also when you edit the subscription for that report again on the same page above, you will be redirected to http://reportserver/Reports/Pages/SubscriptionProperties.aspx page. There is the schedule name which is used by the SQL Server instance where the ReportServer databases are installed.
If you go open Jobs list by using SQL Server Enterprise Manager, you can see the job in the list. Again detailed status information for that job can be seen there. Or by opening the job history screen from the context menu.
Or you can check the Event Viewer for the ReportServer service specific messages.
Eralper|||

Hi:

I set up a report that pulls data from the ExecutionLog table from the ReportServer DB.

If there is an error, it can be read from C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

Regs,

Perry

schedule job backup

Hi there
I want to implement a job command at SQL Server 2000 that should allow the
following:
1. Do a backup to "xpto" database
2. the name generated by the backup should be:
21112006xpto.bak
22112006xpto.bak
...
21022007xpto.bak
After archiving 3 months the first backup craeted "21112006xpto.bak" should
be replaced by "21022007xpto.bak"
once i just want to stay the earlier 3 months.
Actually i use the following command:
BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
backup', SKIP , STATS = 10, NOFORMAT
Can somenone help me or give some tips?...
[]
Ricky
Hi
To create the file using a current date then you would need to use dynamic SQL
e.g.
DECLARE @.cmd varchar(1000)
SET @.cmd = 'BACKUP DATABASE [xpto] TO DISK = N''C:\Microsoft SQL
Server\MSSQL\BACKUP\' + CONVERT(char(8),GETDATE(),112) + 'xpto.BAK'' WITH
INIT , NOUNLOAD , NAME = N''xpto backup'', SKIP , STATS = 10, NOFORMAT'
EXEC (@.cmd)
This will give you are filename YYYYMMDDxpto.BAK. This is a better format as
the files can easily be sorted.
To delete older files check out:
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Alternatively a DTS package using an activeX script would be a way of
deleting old files see http://www.sqldts.com/default.aspx?292
John
"Ricky" wrote:

> Hi there
> I want to implement a job command at SQL Server 2000 that should allow the
> following:
> 1. Do a backup to "xpto" database
> 2. the name generated by the backup should be:
> 21112006xpto.bak
> 22112006xpto.bak
> ...
> 21022007xpto.bak
> After archiving 3 months the first backup craeted "21112006xpto.bak" should
> be replaced by "21022007xpto.bak"
> once i just want to stay the earlier 3 months.
> Actually i use the following command:
> BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
> Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
> backup', SKIP , STATS = 10, NOFORMAT
> Can somenone help me or give some tips?...
> []
> Ricky
>
>

schedule job backup

Hi there
I want to implement a job command at SQL Server 2000 that should allow the
following:
1. Do a backup to "xpto" database
2. the name generated by the backup should be:
21112006xpto.bak
22112006xpto.bak
..
21022007xpto.bak
After archiving 3 months the first backup craeted "21112006xpto.bak" should
be replaced by "21022007xpto.bak"
once i just want to stay the earlier 3 months.
Actually i use the following command:
BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
backup', SKIP , STATS = 10, NOFORMAT
Can somenone help me or give some tips?...
[]
RickyHi
To create the file using a current date then you would need to use dynamic S
QL
e.g.
DECLARE @.cmd varchar(1000)
SET @.cmd = 'BACKUP DATABASE [xpto] TO DISK = N''C:\Microsoft SQL
Server\MSSQL\BACKUP' + CONVERT(char(8),GETDATE(),112) + 'xpto.BAK'' WITH
INIT , NOUNLOAD , NAME = N''xpto backup'', SKIP , STATS = 10, NOFORMAT'
EXEC (@.cmd)
This will give you are filename YYYYMMDDxpto.BAK. This is a better format as
the files can easily be sorted.
To delete older files check out:
http://realsqlguy.com/serendipity/a...th-The-Old.html
Alternatively a DTS package using an activeX script would be a way of
deleting old files see http://www.sqldts.com/default.aspx?292
John
"Ricky" wrote:

> Hi there
> I want to implement a job command at SQL Server 2000 that should allow the
> following:
> 1. Do a backup to "xpto" database
> 2. the name generated by the backup should be:
> 21112006xpto.bak
> 22112006xpto.bak
> ...
> 21022007xpto.bak
> After archiving 3 months the first backup craeted "21112006xpto.bak" shoul
d
> be replaced by "21022007xpto.bak"
> once i just want to stay the earlier 3 months.
> Actually i use the following command:
> BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
> Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
> backup', SKIP , STATS = 10, NOFORMAT
> Can somenone help me or give some tips?...
> []
> Ricky
>
>