Lists the job names and package names for jobs that execute SSIS packages (for packages stored in msdb).

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2017-09-13 (first published: 2017-09-05)

2,084 reads

Blogs

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

How I used AI for this postChatGPT to generate images based on info specifically...

Forums

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

Comments posted to this topic are about the item RegEx Functions II

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)