I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?
If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?
Thanks,
Sam
No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment