External Article

Run SQL Server Agent Job from SSIS

While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?

SQLServerCentral Editorial

Bad Managers

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

Blogs

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

PowerShell Strikes Back: Know Your Quotes, Young Padawan

By

This is Week 1 of PowerShell Strikes Back – a four-week May series for...

A Redgate Data Modeler Gotcha with Relationships

By

This happened to me recently after being busy with non-data modeling tasks for a...

Read the latest Blogs

Forums

BCA KCP Surabaya Telpon/wa:0821°8168°291

By lauraaraujocunha

BCA KCP Surabaya Telpon/wa:0821°8168°291.Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan,...

BCA KCP Kampung Baru Telpon/wa:0821°8168°291

By lauraaraujocunha

Kampung Baru Telpon/wa:0821°8168°291.Jl. Brigjend Katamso No.680, Kp. Baru, Kec. Medan Maimun, Kota Medan, Sumatera...

BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291

By lauraaraujocunha

BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291.Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G,...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers