Yesterday I had a situation where a couple of SSRS reports failed due to a network upgrade.
The SSRS report was not able to access the SQL server that was being used in the stored procedure.
So I had to rerun the report subscription manually.
To re-run the SSRS report subsciption I followed two steps.
I have used the below query to identify the job id of the failed reports.
I have copied the scheduleid and used a filter in the Jobs of the SSRS server as shown below.
Then Right click the Job and click 'Start Job at Step'
There are several other practices to achieve the same result.but I find that this is easier to follow.
Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...