Dear Sir/Madam,
I want my database should send an automatic e-mail to the
user based on Query dynamically. Pls tell me the procedure
to set the maintenance plan according to my query.
Thanks & Regards,
Srikanth
by Srikanth.Goll » Wed, 26 Feb 2003 13:41:54
Thanks & Regards,
Srikanth
by sand » Wed, 26 Feb 2003 18:22:29
Quote:>-----Original Message-----
>Dear Sir/Madam,
>I want my database should send an automatic e-mail to the
>user based on Query dynamically. Pls tell me the
procedure
>to set the maintenance plan according to my query.
>Thanks & Regards,
>Srikanth
>.
by sand » Wed, 26 Feb 2003 18:24:10
"Configuring SQL Mail" under books online
Quote:>-----Original Message-----
>Dear Sir/Madam,
>I want my database should send an automatic e-mail to the
>user based on Query dynamically. Pls tell me the
procedure
>to set the maintenance plan according to my query.
>Thanks & Regards,
>Srikanth
>.
by Darren Gree » Wed, 26 Feb 2003 22:28:57
to export the data into a temp htm file, then attach and send as the message
body using the above xp.
--
Darren Green
http://www.sqldts.com
Quote:> Try "xp_sendmail"
> check for help on this in Books Online
> >-----Original Message-----
> >Dear Sir/Madam,
> >I want my database should send an automatic e-mail to the
> >user based on Query dynamically. Pls tell me the
> procedure
> >to set the maintenance plan according to my query.
> >Thanks & Regards,
> >Srikanth
> >.
1. Btrieve to SQL Server using Data Transformation Services and Data Direct ODBC Driver
I've created a Data Transformation Services package in Enterprise
Manager that has a Transform Data Task to convert Btrieve 6.15 records
to SQL Server 2000 rows. When I execute the package from within
Enterprise Manager, the task works fine. However, when I schedule the
job to run thru the SQL Server agent, the task fails with the message
"[MERANT][ODBC Btrieve driver][Btrieve]The Record Manager is not
loaded." The only way I can get the task to execute as a scheduled job
is to bring up my DDF Builder utility while I'm running the job, in
which case the task executes successfully.
Except for the Btrieve data on an NT server, everything is on my
Windows 2000 machine (SQL database, DTS package). I'm using the
"MERANT DataDirect Connect ODBC Version 4.00 for Windows" driver, and
the Btrieve data is retrieved using the Btrieve 6.15 for Windows NT
Server Edition.
2. logic problem / have data and situation / need help
3. Data Transformation Services and Stored Procedures
5. Microsoft Data Transformation Service(DTS) Package Error
6. Connecting SQL Server 7 to SQL Server 2000
7. Data Transformation Services
9. SQL Data Transformation services
10. Data Transformation Services
11. ADO, VB Script, SQL 7, Data Transformation Services
12. Data Transformation Services problem