SQL Agent Job – Step output file can not be opened. The step was successful

I have many posts with "Step output file can not open." Seen, but can not find references where the step was successful. I have my output file location:

$ (ESCAPE_SQUOTE (SQLLOGDIR)) $ (ESCAPE_SQUOTE (JOBNAME)) _ $ (ESCAPE_SQUOTE (STEPID)) _ $ (ESCAPE_SQUOTE (STRTDT)) _ $ (ESCAPE_SQUOTE (STRTTTM))

Many other jobs on the same server use exactly the same output location (verified exact character match). This job is owned and run as the same user as the jobs that successfully create output files.

The job performs a DB restore of a user database with the job configuration pointing to the master database. This is the only job that points to Master, but I would be surprised if that made all the difference.

Any thoughts?

boot – No video output when booting Ubuntu 18.04 with dedicated GPU

I have a computer running Ubuntu 18.04 and when it's turned on, all the lights and fans are turned on, but no video is output from the graphics card. The specifications are as follows:

  • AMD Ryzen 2600
  • MSI Pro B350 PC Mate
  • Decisive MX500 M.2
  • G.SKILL Aegis 16 GB (2×8 GB)
  • EVGA 1030

The machine stopped working a few weeks ago. There were no major software or hardware changes that coincided with the occurrence of this problem. It was only started one day without video output. The only way to get a video is to turn on the computer without the video cable connected and then connect a DVI cable. However, this rarely works because most attempts still fail to deliver. I only use a monitor.

At first I thought it might be software based, so I tried to restore some older versions of the computer via Clonezilla, but I still did not get a video output. I thought it might be the video card. Since the Ryzen 2600 does not have an iGPU, I could not just take the 710 card out and try, and bought a 1030 because the 710 could have died. Unfortunately, the 1030 has not solved the problem. I also tried to reinstall the RAM, M.2 SSD and make sure all power connections are tight.

I do not know what I can do and hope that I am at least directed in the right direction.

Should a password generator validate the output using a dictionary?

If I want to design a password generator, is it best to leave it really random or validate its output to avoid certain passwords?

For example, if my password generator was really random, it is possible that the output is "password".

Where do you draw the line, just look for common passwords or make sure that nothing in the entire string matches a known word? For example, "fg3 ~ nfpasswordh & tr".

Does this reduce the security of my password generator because it reduces the possible memory space?

Sound – USB-C headphones used simultaneously as input and output

First some background information:

  • I am using Ubuntu 19.04
  • Laptop: Dell XPS 13 9360
  • Earphones: Pixel USB-C Earphones (wired)
  • Using pulse audio with pulseEffects

Most of the time, when I plug in the earphones via the Thunderbolt port, after some work, the audio output switches to my earphones. The problem, however, is to use the earphones simultaneously as an output and input.

When I switch my microphone to "Headset Microphone" on the standard Ubuntu settings page with audio from the earbuds, the audio output will switch back to my built-in speakers, but the microphone seems to work correctly. The opposite is true, if the microphone is working properly and I am trying to switch the output device to the earphones, the input device switches back to the built-in microphone.

When I use the pulseAudio volume control on the Configuration tab, the profiles displayed for the earphones are very inconsistent. By simply removing and reconnecting the availability is changed. These are the combinations I've seen so far:

  • "Stereo output"
  • "Multichannel Output"
  • "Multichannel input"
  • "out"

  • "Digital Stereo (IEC958) Output"
  • "Multichannel input"
  • "out"

  • "Digital stereo output (IEC958) + multi-channel input"
  • "Digital Stereo (IEC958) Output"
  • "Multichannel input"
  • "out"

  • "Analog mono input"
  • "out"

  • "Multichannel Output"
  • "Multichannel input"
  • "Digital Stereo (IEC958) Output"
  • "Analog Stereo Output + Analog Mono Input"
  • "out"

pulseAudio volume control, image

The profiles with the plus sign in the name seem to do what I want. However, these seem to be the rarest and are almost never the default.

How can I make the profiles more consistent or create my own profile to load by default when this device is detected?

windows – FFmpeg: The suitable output format for can not be found [custom format]

I am trying to convert a file with the following command

ffmpeg.exe -i.  kme9le9xeaa31.png -c: v apng.  kme9le9xeaa31.png.cpy

But ffmpeg gives the following error that it can not determine the output file format

It could not have a suitable output format for & # 39 ;.  Kme9le9xeaa31.png.cp & # 39; being found
,  kme9le9xeaa31.png.cp: Invalid argument

Considering that filenames are just metadata and should not be taken at face value, should ffmpeg not interpret them? If not, how can you disable this behavior?

Partitioning – Input / output error on USB

I have a USB drive and have some files copied to it. During the copying process, I accidentally removed the USB port. Now the problem is that I get an I / O error every time you connect the USB. I tried to fix it with GParted, but the same problem. When I load the details of the GParted drive, the output shown in the screenshot below will be displayed.

Input / output error when reading / dev / sdb

I tried to add a new partition table, but it just hangs and hangs.

stored procedures – output result as 2 separate columns

So I've created a procedure that calculates the mean and median of a string array of numbers:

CREATE PROCEDURE dbo.spAvg_Median
@input nvarchar (20)
AS
BEGIN
@ declare split table (id int primary key identity (1,1), number int)

INSERT INTO @split SELECT value FROM string_split (@input, & # 39 ;, & # 39;)

Average SELECT FROM (
SELECT SUM (number) / COUNT (number) as [Average]
        FROM @split
) AS T1
UNION
SELECT MEDIAN (
Select the number AS [Median], rn = ROW_NUMBER () OVER (ORDER BY o.number), c.c
FROM @split AS o
CROSS APPLY (SELECT c = COUNT (*) FROM @split b) AS c
) AS x
WO IN ((c + 1) / 2, (c + 2) / 2)
THE END
BACK 0
GO

However, when you run this query, you get the following result:

EXEC dbo.spAvg_Median & # 39; 1,5,9,8,7 & # 39;

Enter image description here

What I want to spend is average in one column and median in another column next to it.

The UNION command is in place so it will not be output as two different queries like this, because that's not what I want:
Enter image description here