I used these 2 queries a while back to look for indexes that might not be needed. There may be better scripts these days.

"Optimal" number of indexes = All the...

• This reply was modified 2 years, 6 months ago by  homebrew01.

15 on page 1.

1 on page 2.   ( 16 of 15...LOL)

16 total

But no button on either page to get to the other page. I emailed webmaster a few months ago...

• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.

A one-time manual shrink to a specific size might be better than auto-shrink.

"...I've little experience with SSMS, backup & restore etc...."

Download free version of SQL. and start practicing actual backups and restores to point-in-time.

Backup & Restore is a critical role for DBA.

There should be a button to go back to Page 1.

"....I don't see this as a problem, but I am welcome to a URL and browser that might have an issue. I see this, logged in or not....."

Your screenshot has...

• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.

Microsoft Edge  Version 101.0.1210.47 (Official build) (64-bit)

AND

Google Chrome  Version 99.0.4844.84 (Official Build) (64-bit)

• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.

You still have SELECT @job_name,[enable], not SELECT job_name,[enable] as Scott explained.

Maybe you can BCP from a TXT file into a Temp table to start the process ?

Otherwise, with your limitations, maybe copy-paste saved scripts into SSMS. How often does this...

• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.

I see that one but need to put the names of jobs in a text file, cause that will enable and disable all jobs, some jobs I don't want...

Create a group that contains the DBA email address.

Create an IF-ELSE block to send the email if > 30 minutes = YES.

I think your idea is a lot of work.

I would create an operator, and the email address would be a group, such as "SQL Notifications".  You should rarely have...

• This reply was modified 2 years, 6 months ago by  homebrew01.

"....  2. Table aliases - you should get in the habit of aliasing your table references and using the alias on all column references.  It is almost impossible for anyone...

• This reply was modified 2 years, 6 months ago by  homebrew01.

Going forward, get regular differential backups so you have fewer transaction logs to restore.

Some 3rd party backup tools would let you select all the t-logs in the restore GUI. Not...

• This reply was modified 2 years, 6 months ago by  homebrew01.
• This reply was modified 2 years, 6 months ago by  homebrew01.

If you're feeling generous, document as much as you can in a central area, make sure backups run regularly without problems, and hand over as much information as possible to...