Yes Satya...... u r right..... But in SSRS when you schedule a report it creates a job and then schedules accordingly.... Plz go through this...
Hi, I am trying to schedule a report from Report Manager Interface (SSRS 2005) as below: Scenario 1: Start Date: GetDate() [today] e.g:...
Hi, I am trying to schedule a report from Report Manager. What SSRS does is, it creates a job with the help of the SQL Agent and schedules it to the...
Hi, I am using SSRS interface to create and schedule a report. The report parameters are as below... Start Date: 01/03/2008 (dd/mm/yyyy) End Date:...
Yes SSRS stores all the dates in its local time zone. http://www.informit.com/articles/article.aspx?p=470593&seqNum=7
Hi, I have report scheduled in a SSRS. SSRS creates a job and from MSDB.DBO.SysJobActivity the Next_Scheduled_Run_Date column provides the next...
I believe this is the link I was looking for........ :) http://msdn2.microsoft.com/en-us/library/aa256058(SQL.80).aspx
When I am using select distinct I am getting these result..... rsJobWasCanceled rsInternalError rsReportParameterValueNotSet rsParameterError...
Hi, I need to know all the possible 'Status' values of the ExecutionLog in repoting services. Is there any way to find it? presently when i am...
Hi, I am using derieved tables and using left outer join with other tables. Can any one tell me if Left outer joins are faster than inner joins
Separate names with a comma.
