Is there any difference between background script and fix script when we fix some old record?

[Priyanka28]

I need to change the assignment group of some old change request when i asked people for guidance some people told  me by using background and some people suggest me fix script and totally confused which one to use that's why i just wanted to know which one is better or it depends on the condition?

[Dhananjay Pawar]

Hi,

As mentioned above regarding background script is true.

Fix script does have that functionality.

And if you ran query in background script it never stores the code and if in case you want that operation to perform after some days then you have to write code again. And if you use fix script you can save that code and can use later.

Thanks,

Dhananjay.

[Priyanka28]

Thanks Dhananjay

[Sudhanshu Talw1 · Accepted solution]

Hi Priyanka,

No fix script also have rollback option.But by default it is disabled.We have to enable it.

Let me tell you a scenario:

From last 2 days I am running a fix script in the background because I have to delete 5 lakh record.

Why I choose fix script over background?

Because first of all it runs in the background & second no one has the message for transaction waiting as well.

But when i have to check whether my script behaves well or not i ran it in background script for 10 records where I get complete info that which other tables are getting affected with respective operation as well updated/deleted/inserted.

Tip: Whenever you run any script,make sure to use:

gr.setWorkflow(false);//avoid triggering of BR
gr.autoSysFields(false);//avoid sys_upated_by field to show your UserId

Hope it helps.Mark it correct/helpful & close this thread.

Thanks

Sudhanshu

[Priyanka28]

Many Thanks Sudhanshu

Very well explained

[Sudhanshu Talw1]

Pleasure!!