Friday, March 23, 2012
Scheduling
I have uploaded some reports to our reporting services server, however I
want to be able to have them emailed to clients outside the network at the
end of each week,
Can you explain how to do this?
Regards
TimYou can set up a subscription via the subscription tab in Report Manager.
If you are using the Enterprise edition of Report Server you will want to
take a look into Data Driven Subscriptions.
You can find more information here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
Here is information of Data Driven Subscriptions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"catalyst" <catalyst@.discussions.microsoft.com> wrote in message
news:E5DFB9D6-5DD1-4F51-9A2A-E405BD343D84@.microsoft.com...
> Hi there
> I have uploaded some reports to our reporting services server, however I
> want to be able to have them emailed to clients outside the network at the
> end of each week,
> Can you explain how to do this?
> Regards
> Tim
Friday, March 9, 2012
Schedule SQL job from .net 2005
Hey guys I have a job which runs an SSIS package. But as this package needs to run everytime a file is uploaded, I was wondering if sql jobs can help in here...
Does anyone know how can i schedule this job which executes an ssis package frm .net 2005?
Or
Can i write a custom schedule for a job which will check if certain value has changed in the table if yes run the job if no just wait
or do u guys have any suggestions or pointers...
Regards
You could use notification services to file when the upload completes, then have a job start your SSIS package when the message arives in the queue.
Schedule SQL job from .net 2005
Hey guys I have a job which runs an SSIS package. But as this package needs to run everytime a file is uploaded, I was wondering if sql jobs can help in here...
Does anyone know how can i schedule this job which executes an ssis package frm .net 2005?
Or
Can i write a custom schedule for a job which will check if certain value has changed in the table if yes run the job if no just wait
or do u guys have any suggestions or pointers...
Regards
You could use notification services to file when the upload completes, then have a job start your SSIS package when the message arives in the queue.