Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-07-13 : 14:42:37
|
| We use VB and SQL2K.I would like to schedule our reports based on paramters set by the user and the criterias that are specific to the reports.based on these we create the criteria clause and the order by clause and the report name and store it in a table.We also store when this report is scheduled. I was thinking of executing this through DTS.This means,that whenever a job id is created in the job table it will created the same job in SQL DTS and set the timing to the one set by the user. Will this work > |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-13 : 18:26:54
|
| You don't need to use DTS for this, although you could if you wanted. There are other options:1. Create a stored procedure to create the reports and schedule it using SQL Agent2. Create a VB app to create the report and schedule it via NT task scheduler. |
 |
|
|
|
|
|
DTS for other types of scheduling