I could be wrong, but I think you are missing a few ;

I think the command should be:

sqlcmd -S %_var1% -d %_var2% -Q "DECLARE @status varchar(100); exec dbo.sp_RunSQLAgentJob @job_name =...

Sean Lange (9/27/2016)

---

bmg002 (9/27/2016)

---

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so in your case:

JIREM10.dbo.JIRABConcentration

JIREM10...

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so in your case:

JIREM10.dbo.JIRABConcentration

JIREM10 is the database

dbo...

Posisbly a dumb question, but are you enabling the broker? I don't see that in your scripts.

The other thing I'd recommend is to try sending a message outside of...

As a thought - are your database and SSRS instance on the same SQL Instance? If not, did you update both SSRS instance and your database instance?

it sounds to...

Another thought (that we hit in our shop) is if "Option (Recompile)" improves performance, your statistics may be out of date.

How frequently do you re-create statistics or just let it...

Right. My bad.

My version of it would have given you wrong results as it would have started at 0 whenever the date changed.

Good job figuring...

Have you tried using partition by in your second one instead of order by? That is:

SUM(Quantity) OVER (PARTITION BY EffectiveDate ORDER BY Holder RANGE UNBOUNDED PRECEDING) AS TQuantity

you may...