I am trying to create a record producer to give the ability to create a template and schedule a job based on that template all in one step. I am able to create the template. And I am able to create the scheduled job. But, I can't seem to fill the reference field in the scheduled job that links the two. The column name is template and the label is 'Generate This'.
I've been modifying and modifying this script in background to see if I can set the template on the scheduled job...so far no luck.
var si = 'ba828c931b520150423b4111cd4bcbf9';//sys_id of scheduled job
var grit = new GlideRecord("sysauto");//table containing scheduled jobs
grit.addQuery('sys_id', 'ba828c931b520150423b4111cd4bcbf9'); //sys_id of scheduled job
grit.query();
if(grit._next()){
var genthis = '35724c931b520150423b4111cd4bcb5b'; //sys id of template
gs.print('FacPMItem genthis variable = ' + genthis);
}
gs.print(grit.sys_id);
gs.print(grit.template);
gs.print('FacPMItem genthis variable = ' + genthis);
grit.template = '35724c931b520150423b4111cd4bcb5b';// sys id of template
grit.active = 'true';
grit.update();
gs.print(grit.template);
any suggestions or thoughts would be awesome.
