Hi,

If your sure the proxy, credentials are right, and the format is correct like the suggestion above you might want to turn off UAC. I had a similar issue...

Hi,

So many years later, im not sure what i did back then, but now i just use PowerShell. load SQLPS module connect to the CMS Server query the msdb...

Sorry for the delay in replying!

thanks for the link, i had been using that to try and resolve the issue. Finally solved it with playing with AWS network...

hey all thanks for the ideas.

theres certainly some fun ideas to solve the issue. im looking at adding extended properties to everything at the moment and then use PBM...

thanks Nadrek,

I do think drop create is the simplist solution, and the other info is great to..

Thanks Nadrek!

so is this something you do? im interested to see if this is a good idea. or just a nasty workaround..

Regards

S

Little update,

so sp_helptext can return infor on a stored proc, which looks like a way to it. link below. Id be interested to hear how anyone does deployments if...

Hi,

Thanks for the reply, but i think i must have poorly explained my problem.

an example would be,

you want Brent Ozar's SP_Blitz on each machine and you want...

hey thanks,

Ive got a few other small jobs assigned to the same schedule. so will try moving it before then.

Cheers

s

apologies,

so the error is :

Executed as user: svc-009. SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022). The step failed.

All instances are configured the same, I cant find any...

Hi,

thanks for the reply,

msdb is in simple recovery mode,

thanks for the link, its one i used to help build out our msdb clean up jobs. The problem...

🙁

thought so.

thanks for the quick reply..

Hi all,

sorry for the delay in replying, I have it working now,

it was down to the convert.

using

CONVERT ( varbinary(64), sql_handle, 1)

works.

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Thanks for the help

S

hey,

thanks the replies..

Yes its definitely messing with the string when its converts into varbinary, i've tried converting to varbinary max and 64, always the same results of its...

Hey,

can you send a successful test email?

could also try Kenneth Fisher's script which has a few different checks for mail 🙂

http://sqlstudies.com/2013/07/29/notes-on-debugging-database-mail-problems/