SQL Server Agent

[desireemm]

Can I use sql server agent to send reports via email to diffent users????

 

[Catadmin]

You can use SQL Mail to send email to different. SQL Mail is run by SQL Server Agent, but the Agent doesn't actually have any email capabilities by itself.

But what reports are you talking about? SQL Server itself doesn't contain reports. Are you trying to send reports made via SQL Server Reporting Services or Crystal?



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!

 

[desireemm]

See I have some databases with SQL Server 2000 as the engine and Access xp on the user end. I want to create some Reports based off a stored procedure (rather then a view) then have sql email them to different users.

 

[Catadmin]

SQL Server 2000 doesn't, as far as I know, have the capability to create reports. You can use a DTS job to export the info to Access and create a report in Access for it. Then the user can print it out.

Or, export the data as an Excel spreadsheet, text file or CSV and manually send it.

Otherwise, you're stuck with getting an actual reporting program, like SQL Reporting Services or Crystal Reports. I'm not sure if SRS uses SQL Server Agent, but it would be a good bet that it does.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!

 

[desireemm]

thank you so much Catadmin I sure do appreciate it, you have a wonderful weekend

 

[donutman]

Desireemm look at the link right below "so much Catadmin".
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]