Subject For E-mail Notifications

[southcot]

It would be very useful to have “Success” or “Failure” added to the subject line as it would make checking very much quicker. A less useful but better than nothing option would be to incude it on the first line of the e-mail to remove the need to scroll down where there a many tables.

[peterlaursen]

What we do plan to implement very soon is an option to include the MySQL status message like 'x rows affected'.

What is your concept of 'success' and 'failure'?

[TGKnIght]

A little trick I use is to add an extra SQL query into your scheduled action that gives me basically a timestamp of a successful import.

For example, I have some jobs that are set up as “Notification Services”.. After performing any DB operations I want, I add an extra line at the end

Code:

SELECT 'NAME OF IMPORT – SUCCESS', NOW();

Then set the email notification to notify every time. If it is successful, you will get the timestamp back of when the db operation was completed.

Hope this helps in the meantime!

PS To the devs, please don't forget my suggestion of adding in the timestamp into a custom message subject. (VS currently you can either do timestamp OR a custome subject)

[southcot]

For speed of checking I need to know whether there are any problems or not. So for me failure is anything less that 100% of the task.

[peterlaursen]

“don't forget my suggestion …”

We have not forgot! A few days ago we did a rough planning for the next about 3 quarters. this is scheduled for Q1.

[southcot]

Was this abandoned as an option. I back up many DBs each night and for me it would save an enormous amount of time.

[peterlaursen]

Since there is no change for 3 years it look like we have forgotten.  The problem is if it ever will be 100% to add 'success' automatically. Even if server does not return an error and there is no internal error in SJA you may still not have achieved what you want/expect.

But give us one chance more please!

[southcot]

No problem thanks for posting back so quickly. the body of the mail includes a “tables backed up successfully” statement, that is all we can rely on anyway; so perhaps the trigger that produces that result would be fine for the subject line too?

[Khushboo]

Hi,

I have added your request “Option to send the result of the job as a Subject Line in mail” in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1460

Right now priority is not set. But we will discuss regarding this feature in our next team meeting and prioritize accordingly.

Thank you.

Regards,

Khushboo

[southcot]

Thanks

[southcot]

Any news on this, I can't see it in:-

http://faq.webyog.com//content/33/7/en/sqlyog-version-history.html

[Author]

Posts