Scheduling reports to run

Is there a way to schedule reports to run on a specif day and time and save them to excel files?

Hello John,

Yes, of course you can.

Open Report Manager. (http://ServerName/Reports) and drill down to your report you want to schedule. Click on the Properties tab from the tob and the Data Sources tab from the left. Verify that you connection is correct and select 'Credentials stored securely in the report server' and give it an account to run the report. Then go to the Subscriptions tab from the top and hit 'New Subscription'. If you want to save to Excel, then select 'Report Server File Share' and set your options. Down at the bottom, you can set the schedule of the report.

Hope this helps.

Jarret

|||Thanks, Jarret. That's easy enough.sql

Scheduled sql cannot access the network drives?

I have a stored procedure performing several tsql operations with MS
Access and Excel files stored into the network file system, and
therefore using OpenDataSouce with these files in the network,
accessible through mapped network drives.

My user has a profile that maps the necessary network drives at boot.
SQL Server runs on the server with an account created for that. This
accont has also a profile mapping the necessary network drives.

The stored procedure runs fine only if I launch it with SQL Server
Management Studio on the server, logging in directly on the server (at
this point the network drives are mapped correctly).

If I launch the Stored Procedure with SQL Server Management Studio on
my client, it doesn't find the network drives and fails.

The same happens when I schedule the stored procedure on the server
with SQL Server Agent, which runs with an account performing the
mapping in its profile.

Any ideas how to make it work?

A suggestion in common, don′t use mapped network driver, use UNC paths !

If you want to use ressources within the network you will need appropiate permissions either for the service account SQL Server Service is running with or the service account SQL Server Agent is running with (if you do that within a scheduled job). An alternative would be to setup a proxy account for the service [1]

[1] http://www.databasejournal.com/features/mssql/article.php/1580041

In SQL Server 2005 proxy accounts can also be configured through the Configuration interface which you will find in the program collection.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Scheduled Job

Hi ,
I created a batch only to transfer the files from local server to share
folder on another server. I put the batch in the DTS package and scheduled it.
When I trace the job , the file have been copied but the "Status" of the
job still stick on "Executing Step 1 ..." and it no turn to success although
the file had been copied. What's wrong with that actually ?
Thanks ,
Travis
--
Travis TanHi ,
why u are making ur work complex .
U can transfer the files using file tranfer protocol task in DTC
package.
When the batch finishes tanfer sqlserver doesnt come to know the status
and it shows executing status.
from
Doller
Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success although
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
> --
> Travis Tan|||Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success although
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
>
Are you looking at the status in Enterprise Manager? In that case you
might need to refresh it to see the actual status.
Regards
Steen|||Hi Doller ,
Thanks for your info and I understand what you said. The actually process
in DTS was
1) Transfer The Files
2) UnZip The Files
3) Restore the transaction logs
Because the Transfer Files pending in "executing" so no Unzip process is
done. Means that no way for me to resolve that ?
Thanks ,
Travis
Travis Tan
"doller" wrote:
> Hi ,
> why u are making ur work complex .
> U can transfer the files using file tranfer protocol task in DTC
> package.
> When the batch finishes tanfer sqlserver doesnt come to know the status
> and it shows executing status.
> from
> Doller
>
> Travis wrote:
> > Hi ,
> >
> > I created a batch only to transfer the files from local server to share
> > folder on another server. I put the batch in the DTS package and scheduled it.
> >
> > When I trace the job , the file have been copied but the "Status" of the
> > job still stick on "Executing Step 1 ..." and it no turn to success although
> > the file had been copied. What's wrong with that actually ?
> >
> > Thanks ,
> > Travis
> >
> > --
> > Travis Tan
>

Scheduled Job

Hi ,
I created a batch only to transfer the files from local server to share
folder on another server. I put the batch in the DTS package and scheduled i
t.
When I trace the job , the file have been copied but the "Status" of the
job still stick on "Executing Step 1 ..." and it no turn to success althoug
h
the file had been copied. What's wrong with that actually ?
Thanks ,
Travis
Travis TanHi ,
why u are making ur work complex .
U can transfer the files using file tranfer protocol task in DTC
package.
When the batch finishes tanfer sqlserver doesnt come to know the status
and it shows executing status.
from
Doller
Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled
it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success altho
ugh
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
> --
> Travis Tan|||Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled
it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success altho
ugh
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
>
Are you looking at the status in Enterprise Manager? In that case you
might need to refresh it to see the actual status.
Regards
Steen|||Hi Doller ,
Thanks for your info and I understand what you said. The actually process
in DTS was
1) Transfer The Files
2) UnZip The Files
3) Restore the transaction logs
Because the Transfer Files pending in "executing" so no Unzip process is
done. Means that no way for me to resolve that ?
Thanks ,
Travis
Travis Tan
"doller" wrote:

> Hi ,
> why u are making ur work complex .
> U can transfer the files using file tranfer protocol task in DTC
> package.
> When the batch finishes tanfer sqlserver doesnt come to know the status
> and it shows executing status.
> from
> Doller
>
> Travis wrote:
>

Scheduled Emailing of SRS Reports

I've searched this forum for the subject of this post, and have
wandered into long discussions involving byzantine XML into config
files, and complicated class object creation, and I hope this is
mistaken... but is there truly no easy way to simply schedule a report
to be sent via email? I'm hoping for a nice wizard that lets me (a)
pick a report, (b) pick a schedule, and (c) select my recipients...
If there is such a wizard (or, I guess even more importantly if there
isn't), does anybody have a step by step instruction set to get this
to work? Or should I just tell my clients "never mind"...
Many thanks,
DaveA subscription for a report does all this. It is almost a wizard. If
you haven't read up on this, check it out. One issue though is that I
believe that subscriptions require the Enterprise edition.
Neil
On Feb 7, 3:33 pm, "Dave Carr" <d...@.vscrm.com> wrote:
> I've searched this forum for the subject of this post, and have
> wandered into long discussions involving byzantine XML into config
> files, and complicated class object creation, and I hope this is
> mistaken... but is there truly no easy way to simply schedule a report
> to be sent via email? I'm hoping for a nice wizard that lets me (a)
> pick a report, (b) pick a schedule, and (c) select my recipients...
> If there is such a wizard (or, I guess even more importantly if there
> isn't), does anybody have a step by step instruction set to get this
> to work? Or should I just tell my clients "never mind"...
> Many thanks,
> Dave|||Subscriptions are in standard, data driven subscriptions require Enterprise.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<neilgould@.gmail.com> wrote in message
news:1170887444.293038.210870@.k78g2000cwa.googlegroups.com...
>A subscription for a report does all this. It is almost a wizard. If
> you haven't read up on this, check it out. One issue though is that I
> believe that subscriptions require the Enterprise edition.
> Neil
> On Feb 7, 3:33 pm, "Dave Carr" <d...@.vscrm.com> wrote:
>> I've searched this forum for the subject of this post, and have
>> wandered into long discussions involving byzantine XML into config
>> files, and complicated class object creation, and I hope this is
>> mistaken... but is there truly no easy way to simply schedule a report
>> to be sent via email? I'm hoping for a nice wizard that lets me (a)
>> pick a report, (b) pick a schedule, and (c) select my recipients...
>> If there is such a wizard (or, I guess even more importantly if there
>> isn't), does anybody have a step by step instruction set to get this
>> to work? Or should I just tell my clients "never mind"...
>> Many thanks,
>> Dave
>

Schedule backup of data/log files

Is there an equivelant to the SQL Server Agent in SQL server express edition? If not, how can I schedule the backup of the data/log files?

Thanks,

hi,

there's not a direct equivalent.. you can resort on third pary alternatives (http://www.valesoftware.com/products-express-agent.php, never tried it), or you can go for native solutions using the OW native scheduler (AT/SCHTASKS), executing a Transact-SQL statement to perform your desired backup(s) via the SqlCMD.exe command line tool..

just create a cmd file including

[cmd file]

BACKUP DATABASE pubs TO DISK = 'c:\pubs.bak';

[/cmd file]

and schedule it via WinAT at the desired time..

voila..

regards

|||

have a look at the following post...

http://www.virtualrealm.com.au/blogs/mykre/archive/2006/09/01/SQL-Agent-for-SQL-Server-Express.aspx

This is a simple scheduler system that simulates a few of the functions of the agent and might do the job that you need.

Schedule backup of data/log files

Is there an equivelant to the SQL Server Agent in SQL server express edition? If not, how can I schedule the backup of the data/log files?

Thanks,

hi,

there's not a direct equivalent.. you can resort on third pary alternatives (http://www.valesoftware.com/products-express-agent.php, never tried it), or you can go for native solutions using the OW native scheduler (AT/SCHTASKS), executing a Transact-SQL statement to perform your desired backup(s) via the SqlCMD.exe command line tool..

just create a cmd file including

[cmd file]

BACKUP DATABASE pubs TO DISK = 'c:\pubs.bak';

[/cmd file]

and schedule it via WinAT at the desired time..

voila..

regards

|||

have a look at the following post...

http://www.virtualrealm.com.au/blogs/mykre/archive/2006/09/01/SQL-Agent-for-SQL-Server-Express.aspx

This is a simple scheduler system that simulates a few of the functions of the agent and might do the job that you need.