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

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

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

Read the latest Blogs

Forums

Berikut cara menonaktifkan kartu kredit UOB

By affordableseoserviceshub

Untuk menonaktifkan dan menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp...

BCA KCP Senayan City Telpn/wa (08218171891)

By sieuthimayspa

Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...

BCA KCU DARMO TLP/WA 083800209966

By manurung

PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265

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