I would create a second schedule that runs at 6:15 on the first and assign it to all seven jobs. The jobs will now have two active schedules.

Create another job...

Do you have two different schedules? What are those schedules like? Does it run multiple times per day or does it run once, but at a different time if it's...

I think you need the expressions ellipsis in the For Each Loop Editor under the Enumerator.

Choose the FileSpec property and set it to a variable or expression.

December 16, 2022 at 10:28 pm

#4126731

WITH exclude AS
(   SELECT airport_city
    FROM dbo.Airports
    WHERE airport_city IN ('New York City','Los Angeles')
)
SELECT *
FROM dbo.Airports AS a
WHERE NOT...

There are airports with NULL city names which are not returned by the original query.

For this example I would probably use ISNULL(airport_city, '') not in

but generally I avoid NOT IN...

The table needs the same CCI. When I need to do large updates to columnstores I switch one partition into a table with the same clustered columnstore, then create a...

Edit. cross apply may be more efficient.

Do you want to join to a single row in the second table? the one with the latest dt_mev? If so, you can add...

• This reply was modified 2 years, 10 months ago by Ed B.

If you try running the alter table command, check whether it is being blocked. I think alter the table requires a SCH-M lock which may not be possible if the...

I think the trigger fails on error despite the presence of the try catch block. I believe that try catch causes transactions to enter an uncommittable state so the entire...

I don't see the cursor code. Maybe paste it into a code block.

What is there in the business logic that requires a cursor? Does the cursor load the table that...

It looks like you are attempting to create the new schema after it has already been created.

I modified the trigger to just create the @SchemaName schema and it failed because...

Can you simply divide the month number of the date by two? Dividing an integer by an integer causes rounding, so if the month is 5, the result is 2,...

I tried and replicated the issue. I read somewhere that using numeric instead of decimal solves the problem, but that made no difference for me. The only thing I can...

Do you have 15-20 3TB databases on a test server and one of the databases is production?

How much storage do you have? It sounds like you have 30-60 TB in...

This is the same answer as above, but someone has written line by line instructions.

https://anyonconsulting.com/business_intelligence/how-to-configure-an-alert-for-low-log-file-space-for-a-specific-database/