Sushant:

Do you have the backup files of before last night? Please compare if there is big different size with last night that the job failed.

You got email because there are...

Sushant:

which step is for your output of the script? You mentioned there are two steps in your job. There should be two outputs.

Please run:

SELECT j.name, s.step_id, s.step_name, on_success_action, on_success_action, on_fail_action, on_fail_step_id

FROM msdb.dbo.sysjobsteps s INNER JOIN dbo.sysjobs j ON s.job_id = j.job_id

WHERE j.name ='YourJobName'

on_success_action

tinyint

Action to be performed when a step is...

Please run:

select j.name, h.step_id, h.step_name,h.run_status, run_date,run_time,message

from msdb.dbo.sysjobhistory h INNER JOIN msdb.dbo.sysjobs j ON h.job_id = j.job_id

WHERE j.name ='YourJobName'

run_status:

0 = Failed

1 = Succeeded

2 = Retry

3 = Canceled

David:

Thanks

SERVERPROPERTY('ComputerNamePhysicalNetBIOS') offers local node physical name. I am looking for other node names.

ZYT

David:

Thanks.

Is there any t-SQL script that can work from Query Analyzer?

ZYT

magasvs:

Here is the log file. Thanks a lot.

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>

<Locale>en-US</Locale>

<TimeZone>Eastern Daylight Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerService__main_08_04_2010_11_58_21.log</Path>

<SystemName>NSK1501851908B</SystemName>

...

magasvs:

Thanks a lot.

Following your direction, it doesn't work.

ZYT

Steve:

Thanks

Initialization is greyed out in Reporting Services Configuration.

ZYT

Sorry to think about SQL Server 2000, Yes, SP3 of SQL Server 2005. Any advice please?

Hope this can work:

EM - Database - Properties - General - Owner

Map network address as a local hard drive, and give new file name string.

Map data source as a local hard drive. Change Data Source to be the new one.

You can create two temperal tabels, #Column and #Table, that have same column as sp_columns and sp_tables return. Then,

INSERT #Column EXEC sp_column

INSERT #Table EXEC sp_tables

Other databases call two tables and get...