Viewing 15 posts - 1 through 15 (of 148 total)
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...
February 15, 2016 at 2:07 am
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...
November 12, 2015 at 12:28 pm
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...
February 19, 2015 at 4:27 am
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...
October 15, 2014 at 10:34 am
I do think drop create is the simplist solution, and the other info is great to..
October 14, 2014 at 10:31 am
so is this something you do? im interested to see if this is a good idea. or just a nasty workaround..
October 14, 2014 at 8:48 am
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...
October 14, 2014 at 7:09 am
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...
October 14, 2014 at 4:56 am
Ive got a few other small jobs assigned to the same schedule. so will try moving it before then.
September 30, 2014 at 1:13 am
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...
September 29, 2014 at 4:34 am
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...
September 4, 2014 at 2:07 am
thanks for the quick reply..
July 24, 2014 at 2:22 am
sorry for the delay in replying, I have it working now,
it was down to the convert.
CONVERT ( varbinary(64), sql_handle, 1)
Thanks for the help
March 12, 2014 at 6:45 am
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...
March 11, 2014 at 2:43 pm
can you send a successful test email?
could also try Kenneth Fisher's script which has a few different checks for mail 🙂
October 14, 2013 at 2:56 pm