check out msdb table dbo.sysjobhistory

it logs execution times per step.

I'm the same way until I have two 12 ouncers of coffee under my...

• This reply was modified 3 years, 9 months ago by Johan Bijnens.

We use sqlserver alerts ( raiserror 50000+ ) and have sqlagent respond to it and launch a given job.

Keep in mind it may take SQLAgent up to 20 seconds to...

• This reply was modified 3 years, 9 months ago by Johan Bijnens.

the options are documented: Overview of business continuity with Azure SQL Database & Azure SQL Managed Instance

and Restore a database in Azure SQL Managed Instance to a previous...

Oh no ....

Since you're stating your next step is AI, why don't you have a look at Azure SQLDB ?

It gives you SQLServer EE, but with the flexibility of number of cores...

Indeed, Jeff, that operational metadata should be...

another reason to keep up your software level 🙂

If you want to do that using Powershell, I suggest you use SQLSMO or DBATools.

that is a (local) windows managed account, not a group!

double check the path to the sqlagent step log file. Something must be off

Did someone modify the SQLAgent service account after the installation of this sqlserver instance ?

Here is the problem !

Your final query is

INSERT INTO dbo.TAllData(PartID
                 ...

did you specify the "ApplicationIntent=ReadOnly" parameter with your connection and is you secondary readable?

I put dev in read-only restricte mode ( with rollback immediate ) to force everybody out, before attempting to restore.