This article is here to help our banking clients

1. Create a table to hold the list of bank holidays

CREATE TABLE [dbo].[BANK_HOLIDAS](
    [BANK_HOLIDAY] [date] NULL
) ON [PRIMARY]
GO

2. Create SQL script in AETL

skip bank holiday sql

SELECT COUNT(*) AS C  FROM [BANK_HOLIDAS]
WHERE CONVERT(date, [BANK_HOLIDAY]) = CONVERT(date, getdate())

3. Create a package

skip bank holiday package

This simple solution allows the to skip package execution on bank holidays.
Direct link, no registration required.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies