I ran the below script and got the Network related error respectively. I wonder why it takes 2 mins to runt his small script.

EXECUTE AS LOGIN = 'Redmond\MyServiceAccount'

GO

SELECT SUSER_SNAME()

GO

EXEC [MyServerName].MSDB.dbo.sp_start_job...

Sorry Did not quite get your question.

Were you asking, the Service Account that the SSRS is running in has SysAdmin access on the SQL Instance where the Subscription job...

Never mind I figure out a way to get the right Datetime...

convert(varchar(5),DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)/3600)+':'+convert(varchar(5),DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)%3600/60)+':'+convert(varchar(5),(DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)%60)) as [hh:mm:ss]

Ya Its running fine when I kick it off directly.

apparently thats not true at all times. If you see the error message I pasted to you in my earlier reply, I used the same way to kickoff the subscription...

HI Jessie,

Sorry but it did not work. Is still get an error of of Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 67

The specified @job_name ('8A427655-9A6E-43F0-9A28-95C7A8F781B1') does not exist.

Below...

I Have tried the below this but have no luck. I feel I'm missing something really silly.

1) EXEC ('msdb.dbo.sp_start_job ''stakeholderTEST''') AT [TK5BITOOLSVM01];

2) Dropped and recreated the job.

The job that is...

I have done the things that you have suggested but still in the next ETL run, again the Datafile size is boosted up and used space by the file is...

Actually we took extra space while deploying the databases and implementing the application. And now we need that space for new deployments in that server. So, long story short we...

I mean this is 2nd time I'm doing this. Its pain to check on the Shrinkfile SPIDS if there are any blockings or something. It takes 6-7 hours for 1...

Its the LOBs we have a huge column on few tables, is there a better way to maintain LOBs?

I have changed the DB to FULL recovery mode temporarily untill this log space is released back to the disk

Tran backup is not working since there it is not finding...

After the Account and the Profile are created successfully, we need to configure the Database Mail. To configure it, we need to enable the Database Mail XPs parameter through the...

Then can I drop and recreate the DB with My choice of data files?

But wait a min the how can I restore the data if its not possible..

What options...

Now really want know all the possible options that could be done when the DB is in Single user mode and you do not have the control on DB.

1)...