Yes, that helped.

Thank you

Thanks steve, but here are the specific issues I am having :

1) A couple of my scheduled jobs and DTS packages are using sql mail. These jobs run during the night and...

Thanks for your reply. It is possible to do it indirectly using sp_user_counter.

For eg exec sp_user_counter1 <parameter value>

It is being run from a stored proc on sql box. Thanks for your reply

Hello Aaron,

Thanks for your reply -

Here is the view being used :

/* The view returns a single receivable address for based on the max update_date and address_id , This table...

It isn't the system times as there is enought time gap between the 2 jobs, between the time it gets enabled and when it actually runs.

I am updating the...

Hi

Thanks for your suggestion. I will try using a control table but I am curious why the job does not run. The job is enabled and sql agent running. Is...

Here is what's happening. SQL Mail sends out the query results as a text file. Now if we try to save this file with .csv extension, and open in excel,...

I am sorry, It works. My mistake. Thanks a lot !

Yes you can specify multiple queries by separating with (;), but you’ll get the results merged in one file

[/quote]

...

I tried. It doesnt work. Gives a syntax error.

Yes you can specify multiple queries by separating with (;), but you’ll get the results merged in one file

[/quote]