SQL Server Agent

Technical Article

5 (5)

2022-02-22 (first published: )

5,210 reads

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

SQL Homework – July 2022 – Update your resume.

By

Resumes have been on my mind a lot recently. I’ve been thinking that I...

A Blogging Break

By

Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...

Extended Events for Anything But Query Tuning: Unique Constraint Violations

By

Most of the time when I talk about or demo Extended Events, I spend...

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

Power BI Pro License usage based on Operations performed by Users

By rplkrthy

hi Friends, Requirement: Create a query or Power BI report/dashboard that displays users, their...

Extracting Linked Server details from Data Sources of SSRS Paginated Reports

By rplkrthy

hi Friends, Here is the example Scenario: An SSRS Paginated Report has 2 data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers