| Author |
Message
|
| mqjeff |
 Posted: Wed Sep 24, 2014 6:01 am Post subject: |
 |
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| shanms wrote: |
BCZ company is not ready hire more resource  |
Make sure to include your boss on all pages/emails. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Sep 24, 2014 6:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shanms wrote: |
| BCZ company is not ready hire more resource |
And you're not ready to correctly size your system to prevent these (probably spurious) alerts.
As a point of interest, you've developed a system that reports queues filling due to network problems. You get an email every 15 minutes reporting this situation. What do you do with this information? What value is it? The application putting the messages has already failed with a 2053 error so the business people who use that function are SOL, the network people have already failed to respond to whatever monitoring they have in a timely fashion so what use is you reporting that you have an inbox full of errors? The application people already know and the network people already know and don't care.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shanms |
| Posted: Wed Sep 24, 2014 7:59 pm Post subject: |
|
|
Apprentice
Joined: 17 Jun 2014
Posts: 38
|
Hi Vitor,
Thanks for your reply ,yes it's correct what your saying ,for temporary purpose i will use this automation.May be in feature i will get something else. |
|
| Back to top |
|
|
| exerk |
| Posted: Thu Sep 25, 2014 12:00 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| shanms wrote: |
| ...May be in feature i will get something else. |
Then make your solution as management-unfriendly or flaky as you can because 'tactical' solutions such as this have a very n.a.s.t.y habit of becoming 'strategic' because they work, albeit at a very low level of what is actually required.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 25, 2014 5:01 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shanms wrote: |
| for temporary purpose i will use this automation. |
For what? I still don't understand how this helps.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shanms |
| Posted: Wed Oct 01, 2014 2:08 am Post subject: |
|
|
Apprentice
Joined: 17 Jun 2014
Posts: 38
|
Hi Vitor,
Here is my script details.
one mqsc file
one vb script(for email alert)
one text file(which will copy the result)
one batch script
mqsc file contains :dis ql(queue name) CURDEPTH
vb script contains the the alert mail :
| Code: |
Dim objFSO, filepath, objInputFile, tmpStr, substrToFind, tmpSStart, tmpSend, tmpSChar, tmpSVal
Set objFSO = CreateObject("Scripting.FileSystemObject")
filepath = "\queuedepth.txt"
substrToFind = "CURDEPTH("
Set objInputFile = objFSO.OpenTextFile(filepath)
do until objInputFile.AtEndOfStream
tmpStr = objInputFile.ReadLine
If InStr(tmpStr, substrToFind) <=0 Then
rem WScript.Echo "No matches"
Else
rem wscript.echo tmpstr
tmpSStart = InStr(tmpstr,"(")
tmpSEnd = InStr(tmpstr,")")
tmpSEnd = tmpSEnd -1
tmpSChar = tmpSEnd - tmpSStart
tmpSStart = tmpSStart + 1
tmpSVal = Mid(tmpstr,tmpSStart,tmpSChar)
rem wscript.echo tmpSval
if tmpsval>=100 then
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "- QUEUE DEPTH EXCEEDED - " + tmpstr
objMessage.From = "mail id"
objMessage.To = "mail id's"
objMessage.TextBody = "The Current Queue Depth is " + tmpsval
' Configure the send to use another server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") =
' Now we provide the configuration information for the remote SMTP server
' (normally you will only change the server name or IP)
' Name or IP of Remote SMTP Server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = ""
' Server port
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") =
' Save the new configuration settings
objMessage.Configuration.Fields.Update
objMessage.Send
end if
End If
loop
objInputFile.Close |
EDIT by exerk: please use code tags in future, thank you.
Finally batch script contains the
del Z:\...\queuedepth.txt
runmqsc QMGR <Z:\....\dispqm.mqsc >> Z:\...\queuedepth.txt
Z:\...\Email.vbs |
|
| Back to top |
|
|
| vicentius |
| Posted: Wed Oct 01, 2014 2:16 am Post subject: |
|
|
Apprentice
Joined: 01 Mar 2013
Posts: 28
|
| I'm sure Vitor was more interested in how this contraption helps you when smelly hits the fan. What value does endless streams of emails that stuff went wrong add to the whole solving of undesirable situations? |
|
| Back to top |
|
|
| shanms |
| Posted: Wed Oct 01, 2014 2:48 am Post subject: |
|
|
Apprentice
Joined: 17 Jun 2014
Posts: 38
|
Hi vicentius,
My concept is simple,if my queue reaches 100 above then i will get a mail alert.
it's already implemented per day i am getting 3 to 4 mails. |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Oct 01, 2014 3:19 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| shanms wrote: |
| My concept is simple,if my queue reaches 100 above then i will get a mail alert... |
In the great scheme of things a depth of 100 is pretty negligible...
...and what method are you using to ensure your email wakes you up at night?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Oct 01, 2014 6:57 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| exerk wrote: |
| shanms wrote: |
| My concept is simple,if my queue reaches 100 above then i will get a mail alert... |
In the great scheme of things a depth of 100 is pretty negligible...
|
Its all relative I suppose.
If each message contains "We successfully pulled $1000.00 from exerk's account, and he never noticed.".....
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Oct 01, 2014 7:06 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| PeterPotkay wrote: |
| "We successfully pulled $1000.00 from exerk's account" |
That's quite optimistic of you.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 01, 2014 7:44 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vicentius wrote: |
| I'm sure Vitor was more interested in how this contraption helps you when smelly hits the fan. What value does endless streams of emails that stuff went wrong add to the whole solving of undesirable situations? |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Oct 01, 2014 8:02 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| PeterPotkay wrote: |
| exerk wrote: |
| shanms wrote: |
| My concept is simple,if my queue reaches 100 above then i will get a mail alert... |
In the great scheme of things a depth of 100 is pretty negligible...
|
Its all relative I suppose.
If each message contains "We successfully pulled $1000.00 from exerk's account, and he never noticed."..... |
Fair point...
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Oct 01, 2014 8:03 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| mqjeff wrote: |
| PeterPotkay wrote: |
| "We successfully pulled $1000.00 from exerk's account" |
That's quite optimistic of you.... |
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| shanms |
| Posted: Wed Oct 01, 2014 8:56 am Post subject: |
|
|
Apprentice
Joined: 17 Jun 2014
Posts: 38
|
Hi All,
my script is giving alert for above 100 queue depth after 15mins it should not get any alert bcz with in 15mins msg will be processed ,if msg are not processed then again mail will come .script will run every 15mins,this span of time 99% msg will process if not something going wrong with system,for this purpose only we prepared this script. |
|
| Back to top |
|
|
|
|
