I have one update statement. It will update, when we manually run the query.

Question

question

balu.arunkumar asked Jul 26, '13

I have one update statement. It will update, when we manually run the query.

But it will not update when we put the same statement in Job. Pls find below query. UPDATE EXISTING_TOPUP SET [DESCRIPTION]=B.[DESCRIPTION] FROM EXISTING_TOPUP A,mis.dbo.LT_ALL B WHERE A.ACCOUNT=B.MSISDN AND B.recharge_date=convert(varchar(8),getdate()-1,112) UPDATE EXISTING_TOPUP SET [DESCRIPTION]=B.[DESCRIPTION] FROM EXISTING_TOPUP A,mis.dbo.LT_ALL B WHERE A.ACCOUNT=B.MSISDN AND B.recharge_date= convert(varchar(8),getdate()-1,112)

update

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-07-26T11:10:24Z

ThomasRushton answered Jul 26, '13

Have you told the job which database to execute the statement in? Either prefix your statement with: USE DatabaseName or fully qualify the object name: UPDATE DatabaseName.SchemaName.Existing_topup ... FROM DatabaseName.Existing_topup A, MIS.dbo.LT_ALL B ... or, when setting up the job, there's an option to say which database...

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

eaglescout commented · Jul 26, 2013 at 02:55 PM

Great thinking @ThomasRushton ! I've made this mistake before and correcting it to the full data source path name solved it.

0 ·

question