Just an update, the job history log is been written on the logfile, the check mark " append to the existing file" on the advance tab on job step property,...

All,

Just thought to give every one a update. the job ran successfully tonight and the log was written to the file. I am going to wait for the next failed...

Even though, this is a 3 year old thread but just would like to add that I agree with Jeff, my ID was part of the local admin, I was...

Thanks.

will contact Ola, once i get the failure in the txt file.

Gail,

Thanks for the quick response, would like to make sure if I followed it correctly. the job will run tonight and will let you know how the logging went.

To update...

OK, I think I get it now, so as long as the database is up , i can take a new backup with a new password and restore it on...

Thanks,

Yes I am the admin, the database in online. please also note that i do have database certificate files. i just don't have the password. please let me know...

Thanks a lot, i already found the update statement and it solved my problem.... Thanks again.

Guys,

i really need help in this, i know people have explained the issue but i cant seems to be able to make it work.

in my environment i cant delete...

i understand , but in this box.. because of the bad application code lot of temporary tables are not getting drop... from last month of so. i want to drop...

Thanks for the input.

i took out the owner from the cursor the SP executes successfully but does do any thing, meaning none of the temp tables get deleted.

can Lowell or...

Thanks Lowell,

I grayed out the part " SELECT tempdb.dbo.sysobjects.name --tempdb.dbo.sysobjects.*"

but it gave the same error when executing the SP

"Msg 16924, Level 16, State 1, Procedure sp_DropTempTables, Line 15

Cursorfetch: The number...

Thanks Barry,

it makes sense. can you please let me know where to make changes in the code, sorry I am kind a new at this and for the past month...

No, it doesn't,, i have looked in to it and reached a conclusion there is no table that can tell you when the ssis was fired ,,, the logging...

Firstly, Thanks for the reply.

the way you have mentioned , i will definitely look in to it. is it ok for me to assume than there is no way...