Integration Services (SSIS)

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

Friday Flyway Tips: Chaining Commands for State-based Deployments

By

One of the cool things I’ve seen with the new Flyway CLI is that...

A New Word: Querinous

By

querinous – adj. longing for a sense of certainty in a relationship; wishing there...

How to clear the SSMS cache?

By

How to clear the SSMS cache? If you are reading this,...

Read the latest Blogs

Forums

standard deviation function doesnt seem to be behaving like an aggregate

By stan

hi i have 6 statistical populations in my overall data set.  They run across...

SQL Server Data...is it encrypted?

By water490

Hi Suppose someone gained unauthorized access to the physical SS data stored on my...

The Weather Outside Is Frightful

By Grant Fritchey

Comments posted to this topic are about the item The Weather Outside Is Frightful

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers