SQL Server Agent

Run SQL Server Agent Job from SSIS

  • Article

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?

2020-05-19

Blogs

Blog .NET for Apache Spark UDFs Missing Shared State

By

The Problem When you use a UDF in .NET for Apache Spark, something like...

Migrating SQL Server container images to the Github Container Registry

By

A couple of months ago Docker announced that they would be implementing a 6...

Daily Coping 29 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to improve the performance of insert?delete?update sql statement

By 892717952

as it was said in the title, which we should pay attention to when...

TDE Drama

By Brandie Tarvin

My workplace uses a 3rd party key management system as an encryption provider for...

The Best Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Best Query

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers