SQL Server Agent

External Article

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

Creating a new User-Defined Data Type–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

A new chapter begins

By

In 2012 when I originally founded Born SQL, I never imagined I would find...

Daily Coping 19 Jan 2022

By

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

Read the latest Blogs

Forums

Recursive Triggers

By Ken at work

I know there is, somewhere, T-SQL that will allow me to update (keep in...

How to get cummulative sum per column?

By Barendrecht82

Hi, I have a statement per period. I want the periods to be cumulate. ...

Secondary Filegroup

By jayoub

Hi, I have a quick question If I have a database with a primary...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers