Hello ,

Were you able to solve this problem? I have the same problem. DId everything nothing...

thanks everyone..but thats not what i am looking for. I DO NOT WANT TO SETUP Logshipping from secondary to primary..all i need is to sync the primary and secondary after...

On a 64 bit sql server with windows 64 bit you will need two versions of Oracle clients

i) 10 G 64 bit for Linked Servers

ii)11 G 32 bit for ODBC/OLE...

rudy excellent script

thanks everyone...the same job takes only 40 mins on their old servers..i compared the settings everything looks to be the same...i know ders no point in using the linked server...

thanks Greg...but the only problem with filesystem is like the packages need to go under certain security policy like "rely on server storage for access"..i dnt think i can make...

Hello Justin, i had the same issue before...after spending hours troubleshooting i found for few procedures when it runs through mgmt studio works fine but throug a job fails because...

hmm ok..thanks Greg....i was just wondering isnt there a procedure like "sp_changeonwner" something which i can assign...i will also do some research and see..thanks,

thank you for responding..i do not want the user to change to sa because he will not be able to run as only sa can run the job if...

thanks..but the post talks only about DTS...im looking to create a role for the jobs with the respective actions which i mentioned in my initial post..

hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to replicate...

after deleting and re-creating the job..so far it worked fine in test..i will have to observe few more days..thanks everyone for suggestions..

thanks Matt, i do not see any error. ..let me see..thansk

thanks Steve, i did delete the job and recreated. I will keep updated thanks,

thanks mano, i checked the articles are really interesting but none of them is related to the my job issue. I went through the checklist provided in the article, evrything...