maint. plan fails but doenst report error

Hello

I have this maint. plan where each and every step has been failing the last couple of days. The problem is, it doesn't write anything to the error logs. It only reports to the application log that each step of the plan has failed.

I suspect this might be a user rights problem, but it's difficult for me to say. What kind of rights are necessary for writing to the error logs?

In general, what rights are necessary for the user that runs the SQL Server Agent? And has anybody else experienced something similar?

MNJThis is mostly about scheduling a DTS package as a job. However, the security aspect of it should pertain to your situation as well.

Go Here: http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 (Microsoft Knowledge Base Article 269074)

MailTo html in SELECT Statetment?

How do I write a SELECT statement to return one of the selected fields as a mail to link?
Thanks for helping a SQL newbie.
Scott

I'm a little confused. You'd do a SELECT emailAddress FROM yourTable, and then you would just plop the value into an anchor tag with a "mailto:" prefix.
Do you have some code that is not working correctly?
|||

Thank you for responding.

I'm using Dave O'Leary's Advanced DataGrid to pull content out of a MS SQL 2000 table in a DNN3 application.
Heres the statement:
SELECT TOP 5 Title, Price, EmailContact FROM cs_ClassifiedsItem ORDER BY CreatedDate
The DNN module stores classified ad information. The email address is stored as a character string and is returned as a mailto link at runtime. Advanced DataGrid simply returns the character string. I'd like to add code to the SELECT statement to return the email character string as a mailto link.

Mr. O'Leary provides the following guidance on his websitehttp://www.efficionconsulting.com/Default.aspx?tabid=217:

Q. Can the Grid display images and/or Links? A. Yes. To do so, you basically need to return the appropriate HTML so, you can either store the full HTML in the database field or, in the select statement you can add the HTML, i.e. SELECT '<img src=' + ImageName + '>' FROM LinkImage. I have not been able to get this to work using various forms of mailto tags. Help is much appreciated. Thanks, Scott

|||Then something like this might work for you:

SELECT TOP 5
Title,
Price,
'<a href=''mailto:' + EmailContact + '''>' + EmailContact + '</a>' AS MailToLink
FROM
cs_ClassifiedsItem
ORDER BY
CreatedDate

I don't think that mixing presentation code with data access code is a good idea, however.
|||Thank You! And I appreciate your guidance on mixing code.
Scott