Okay thanks Doug.

Hi Doug,

So what should be my WHERE conditopn be? If I put a WHEERE Clause as freq_type = 1, no output is displayed.

Hi All,

I was able to get some help and got the query. But it doesn't work if we select "Occurs once at" in the Schedule section of the job....

Thank you Gail.

Thanks Gail. If you don't mind, can you please elaborate the 1st question answer? regarding network round trips? Its little top of my head.

I pasted from GUI. Went to the Job properties -> Schedules.

Programmatically, we have to get it from msdb.dbo.sysschedules.

Anybody ???

Repeating the requirement,

For example, The job is scheduled to execute every 1 hour in a day (Occurs every day every 1 hour(s) between 12:00:00 AM and...

Hi TripleAxem

Answers Inline.

Are you updating the statistics on the table in one command i.e. update statistics <tablename> or updating individual statistics one by one i.e. update statistics <tablename> (<statisticsname>)...

Thanks Orlando. That clears a lot of doubts.

Hi Orlando,

Thanks for the response. I am basically looking for 2 clarifications here.

In AG, does Primary replica will be sending log records constantly to secondary and applied on secondary...

Can anybody share their thoughts or comment above understanding?

its not a permission issue. the account has db_owner on the database. But something is missing here. Alwayson is a db mirroring which sends log records from Principal to Mirror(i.e....

Yes, the database is part AG.

Thank you Lowell. Will try the workaround 🙂

All I see from SQL Agent Job history is,

Error Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description:...