I am getting no errors upon executing your query.

I tried all the steps mentioned by you. None of them report any error messages.

Thanks,

-Mohsin

Job is executed with local admin as "NT AUTHORITY\SYSTEM"

Job logs report as follows,

"Mail queued. [SQLSTATE 01000]

Job 'DBAdmin--- Space alert' : Step 2, 'email' : Began Executing 2009-10-05 02:42:28"

No errors in event viewer. If I am using script to...

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER view [dbo].[v_udb_extract_contract]

as

select

'I' as inp_source_code

,LS_MASTER.CONTRACT_NO as contract_id

,LS_BILLING.REMIT_TO as remit_to_cd

,LS_AADDR.AR_NAME as customer_name

,LS_AADDR.AR_CITY as ar_city

,LS_AADDR.AR_STATE as ar_state

,LS_AADDR.AR_ZIP...

Copy the backup file to some other location and delete the  original file from the backup location. Re start the job and it will work fine.

Thanks,

-Mohsin