New answers tagged

0

I wanted the current step number and name. I had restarted the job in step 42; it was showing me step 1. -- Show Currently running jobs and the current STEP NAME -- Borrowing from noted URLs, I added code to get STEP NAME of CURRENTLY RUNNING STEP, FINALLY!!! -- https://www.databasejournal.com/features/mssql/article.php/10894_3491201_2/Detecting-The-...


0

It seems there are many who has faced this issue in the past and they all have implemented one or the other work-around to get rid of it. Not documented at Microsoft site or presented by any known SME(Subject Matter Expert). First of all, I would say database mirroring is deprecated and will not be supported by Microsoft in near future, so you should plan to ...


1

For those like me who got here from Google: pscp now has a -hostkey option which can be used like this: pscp -P 22 -hostkey "ssh-ed25519 255 aa:bb:cc..." ... This eliminates the need for an interactive PuTTY session to store the host key. Here's what the documentation has to say: -hostkey key Specify an acceptable host public key. This option may ...


-1

Go to connection properties -- type msdb instead of default under options > connection properties > Connect to Database > msdb -- then connect


Top 50 recent answers are included