No response yet !! any ideas are also welcome.

I believe that step is not failing even if the file is not there, i have came across times when the steps should fail but instead they complete without doing...

Tried prepending schema but of no use...any other ideas...

I do not want to concatenate the query.

My sole aim is th pass the table name at run time, please do let me know if there is anyway we can...

Have you checked the entry for oracle server in sql server tnsnames,ora file...?

Do one thing, go to 'Job System'  tab in SQL server agent properties.

In 'Non-sysadmin job step proxy account' uncheck the checkbox if its checked and click on 'Reset proxy account'...

there is no predefined priroty list, in fact the problem is od dml only since they can execute one at a time.

Moreover the transaction which will take less time is...

what for you are using token [A-MSG]?

Are you using xp_sendmail for sending mail or xp_smtp_sendmail??

hi,

thnx for your quick response but that script doesn't show the patch info. as when the last patch applied (I am not talking of service packs) what was the type...

Since in FAT32 the max file size can be 4GB minus 2 bytes so it can't take backup of 5 gb db change it to NTFS which can handle upto...

Thanks, but I already did those 2 things

I also came across the same error and the reason was the profile which you are using for SQL mail setting.Be sure that the profile you have configured is working...

I just wanted to use FilesystemObject object or sp_OAcreate to create excel file please

Can u clear ur problem please

This statement is unclear :

"when using my Enterprise manager on my XP machine i get multiple logins and logoffs on the servers "

what do...

For getting actual file used if you are using single file you can use command

dbcc sqlperf(logspace)