Create a daily scheduled job

Thanks for the quick response. It was my mistake. Its SQL 2000 and not SQL 2005. Any way to get this one on SQL 2000.

It works about the same way, but with DTS...

http://msdn2.microsoft.com/en-us/library/aa933541(SQL.80).aspx

http://www.devguru.com/features/tutorials/DTS/DTS3.asp

Thanks Chapman. I was able to create the DTS part and have it talk to the right database. However, my query isn't quite working right. With the information given above under description, would you be able to tell me what the query should look like. I want to be able to pull out a few other fields along with it, when the domainname matches the string xxx.

Thanks,

PK

The standard query I have posted in my description works well when I'm querying from a table. However, when I put the same query in DTS, it doesn't work. It gives an error.

Do you get an error?  why is it not "working right"?

Let's make this easy. The following query works fine. It creates the excel output.


CREATE TABLE `Results` (
`TIMSTAMP` DateTime ,
`USERNAME` VarChar (255) ,
`WorkstationName` VarChar (255) ,
`COMPUTERNAME` VarChar (255) ,
`Info` VarChar (255),
`domainname` VarChar (255)
)

What I want it to do is to be able to pull out the TIMSTAMP, USERNAME, WorkstationName, ComputerName, Info, only when the Domainname field matches the string XXX. For that to happen, I changed it to the following.

CREATE TABLE `Results` (
`TIMSTAMP` DateTime ,
`USERNAME` VarChar (255) ,
`WorkstationName` VarChar (255) ,
`COMPUTERNAME` VarChar (255) ,
`Info` VarChar (255),
(DOMAINNAME VarChar CHECK (DOMAINNAME =XXX))
)

Is this the right way of doing it to begin with?

Thanks in advance

The error I got for the above query was "Error Source : Microsoft JET Database Engine Error Description: Syntax error in field definition."

try this:

SELECT *
FROM `Results` WHERE DomainName = 'XXX'

The above query wont work since the results isn't table that exists in the database. Its a table I created as part of the DTS query. Since it doesn't exist otherwise, it errors out saying unable to find objects 'results'.

However they way we can get this to work would be, a new table gets created everyday in the database with a timestamp attached to it. The name of the table is prathap_table_200803160000. Since these reports should be run everyday , if we can attach the timestamp to the database fro the system date, then it mgiht work. This sounds even more complicated. Just a thought.

You can do it...make sure the connection of your query is the XL file, not the database connection.

Where doy ou want to attach the timestamp in the database from the table?  That is easy enough to do....

I was thinking we can attach the timestamp to the query you had created. For example, in the query below, timestamp should be the date for that particular day added to the table name. While the first part of the name doesn't change which is prathab_table, the second part of the name changes with the date. Its in this format prathap_table_200803160000.

SELECT *
FROM `prathab_table(timestamp)` WHERE DomainName = 'XXX'

As I said earlier, this query below works fine, no need to mess with the timestamp,. I'm justnot able to throw in the condition. There are three different entries for domainname and they are lets say xxx, yyy, zzz. I only want the data when the domain name is xxx. It cant be too hard, It has to be pretty easy. Per the instruction, there is a check constraint that goes with the create table command. I have no idea why it wont. The connections are fine. If I remove the check command, the query works perfectly and Im able to get the report I want. Only thing I m having difficulty with this is the condition.

CREATE TABLE `Results` (
`TIMSTAMP` DateTime ,
`USERNAME` VarChar (255) ,
`WorkstationName` VarChar (255) ,
`COMPUTERNAME` VarChar (255) ,
`Info` VarChar (255),
`domainname` VarChar (255)
)