Click here to Skip to main content
15,440,955 members
Home / Discussions / Database
   

Database

 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 10:46
professionalEddy Vluggen17-Apr-14 10:46 
Questionwhy looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 0:04
MemberJassim Rahma16-Apr-14 0:04 
AnswerRe: why looping is not starting from my start date? Pin
jimbowAX16-Apr-14 3:04
MemberjimbowAX16-Apr-14 3:04 
QuestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:01
mveRichard MacCutchan16-Apr-14 6:01 
AnswerRe: why looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 6:14
MemberJassim Rahma16-Apr-14 6:14 
SuggestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:29
mveRichard MacCutchan16-Apr-14 6:29 
GeneralRe: why looping is not starting from my start date? Pin
jimbowAX22-Apr-14 7:32
MemberjimbowAX22-Apr-14 7:32 
QuestionEmail Notification trhu SQL SERVER using SMTP Pin
Member 1075257815-Apr-14 21:09
MemberMember 1075257815-Apr-14 21:09 
Hi All,

Hope everyone is doing great!!!.
I am new to this group so any mistake in posting, i am sorry.

I have a scenario, We have 5000+ scheduled jobs in the scheduler tool and the back end for that tool is sql server. We are manually monitring the job status and failuers which is taking huge efforts.

For automating the monitoring process, we want to have Stored procedure which can be triggered when there is failure or status of jobs ran for every hour. I need help as how to have body of the message for reporting the job status and run times.

I got the SP, but how to get the body of the message is what i am stuck with. Below is link from where i check the code.

Please let me know if you need any information.

Thanks a lot for your help in advance.

Regards,
Deepa

http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/[^]
AnswerRe: Email Notification trhu SQL SERVER using SMTP Pin
jschell17-Apr-14 10:07
Memberjschell17-Apr-14 10:07 
QuestionRecurring job orders timeing out after about 32 seconds Pin
Jassim Rahma14-Apr-14 23:54
MemberJassim Rahma14-Apr-14 23:54 
AnswerRe: Recurring job orders timeing out after about 32 seconds Pin
Richard Deeming15-Apr-14 2:30
mveRichard Deeming15-Apr-14 2:30 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Jassim Rahma15-Apr-14 2:47
MemberJassim Rahma15-Apr-14 2:47 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Richard Deeming15-Apr-14 2:54
mveRichard Deeming15-Apr-14 2:54 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Jassim Rahma15-Apr-14 2:55
MemberJassim Rahma15-Apr-14 2:55 
QuestionMySQL A connection attempt failed because the connected third party did not properly respond after a period of time Pin
Jassim Rahma12-Apr-14 1:57
MemberJassim Rahma12-Apr-14 1:57 
AnswerRe: MySQL A connection attempt failed because the connected third party did not properly respond after a period of time Pin
Jassim Rahma14-Apr-14 23:55
MemberJassim Rahma14-Apr-14 23:55 
Questionconvert Pin
Member 1074305611-Apr-14 10:33
MemberMember 1074305611-Apr-14 10:33 
AnswerRe: convert Pin
Mycroft Holmes11-Apr-14 13:35
professionalMycroft Holmes11-Apr-14 13:35 
QuestionDatabase with direct TCP/IP access? Pin
Marco Bertschi10-Apr-14 23:17
professionalMarco Bertschi10-Apr-14 23:17 
AnswerRe: Database with direct TCP/IP access? Pin
Eddy Vluggen11-Apr-14 0:38
professionalEddy Vluggen11-Apr-14 0:38 
GeneralRe: Database with direct TCP/IP access? Pin
Marco Bertschi11-Apr-14 1:14
professionalMarco Bertschi11-Apr-14 1:14 
AnswerRe: Database with direct TCP/IP access? Pin
Eddy Vluggen11-Apr-14 8:04
professionalEddy Vluggen11-Apr-14 8:04 
GeneralRe: Database with direct TCP/IP access? Pin
jschell11-Apr-14 9:52
Memberjschell11-Apr-14 9:52 
Questiondatabase auto-growth setting Pin
kyi kyi10-Apr-14 22:17
Memberkyi kyi10-Apr-14 22:17 
AnswerRe: database auto-growth setting Pin
Marco Bertschi10-Apr-14 23:19
professionalMarco Bertschi10-Apr-14 23:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.