May 21, 2003 at 5:19 am
Hi all,
I've got lots of SQL SERVER Jobs.
each job at the final step should generate and mail a report with:
job name, job start date, instance name etc.
Don't know if doing this the right way, but I plan to add one step
to the job which will execute SP. SP will prepare the report and
send an e-mail (using CDO, because i don't have MS Outlook or
Exchange or other proper MAPI client on SQL SERVER machine...
notification tab is useless for me 🙁 ). Now i need to pass as a
parameter the active job name, start date, instance name... how do
I do that? is it possible? or should i search for another solution?
maybe i should use DTS package instead and encapsulate the whole
logic into it. I think it wold be more flexible... or maybe You
know of some freeware mail client? 😉
With regards
Maciej Szymanski
With regards
Maciej Szymañski
May 21, 2003 at 5:27 am
It's ok, but a lot of effort to add a step to every job, then when you change something, have to change them all possibly. How about just reporting from sysjobhistory? Greg Larsen has an article here on the site that discusses a failed job report, might be a good starting place.
http://www.sqlservercentral.com/columnists/glarsen/failed_jobs.asp
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply