thanx for ur help

but we usually cjheck the view job history to view how long the job has run. what i need to know is, when u start a job, is...

Thanks 4 ur reply.

I see that when u run that query, it shows a status column with 10. Does this indicate that it's active and what will the status be...

thank you very much Patrick

Hi dclark

Will the command look like this: exec xp_cmdshell 'psinfo -d'?

I'm executing this command but I'm not getting the results that I need.

Am I doing this right?

Regards

thanks alot for ur help

What do u mean by SQL Generic refresher. I checked out what spid 51 and there is a column called Status and it says runnable. Does this mean that the service...

Thanks, I already figured this out.

Regards

thank you very much

Hi Tommy,

Thanks, I did what u suggested and no error pops up. However the mail is not sent to the destination address.

Here is a list of all the items that...

Hi,

I don't know what happened but for some reason the DTS worked. Thanks for ur help.

Regards

Imke

Hi,

The query works fine in Query Analyser. When clicking on the OLE Source Editor's preview button the data is displayed. It however does not want to display in the Excel...

Hi Daniel,

I only get the columns names onto the spreadsheet. When I click preview in the datasource nothing is displayed, only the column names.

Hi Daniel,

I tried what u suggested and it and the DTS runs fine, thanks. However none of the data is being displayed within the Excel spreadsheet. I am using the...