Scheduled Job not running even on Execute Now

[rpatnaik]

Hi All,

Need a help in running the Scheduled job.The scheduled job is convert a risk into an issue after 10 days of the due date in Risk Form.The Risk state has to be 'Convert Issue' once the issue is created .But the Scheduled job is not running on the Scheduled time or on clicking  the 'Execute Now'.But when i run it from the background Script i get the expected outcome.

Please help me to run the script.

Script is as below:

var ps = 10;
var pn = parseInt(ps);
var gt=new GlideDateTime();
var query ='issueISEMPTY';

if (pn >= 0) {

var grrisk= new GlideRecord('risk');
grrisk.addEncodedQuery(query);
grrisk.addQuery('due_date', '<', gs.daysAgo(pn));
grrisk.addQuery('sys_id','*****************');
grrisk.query();
while(grrisk.next()) {

var grissue = new GlideRecord('issue');
grissue.short_description = grrisk.short_description;
grissue.description = grrisk.description;
grissue.assigned_to = grrisk.assigned_to;
grissue.risk = grrisk.sys_id;
grissue.parent = grrisk.task;
var issueSys = grissue.insert();
grrisk.issue = issueSys;
grrisk.state = 'convert_Issue';
grrisk.update();

}
}

Thanks in advance

Rashmi

[Harsh Vardhan]

are you doing it on personal instance ? is it possible for quick webex?

[rpatnaik]

Not in personal Instance

[rpatnaik]

On my personal instance it has executed as Scheduled

[Harsh Vardhan]

if still not working . create new one and test it. 

[rpatnaik]

I created a new one but still the issue persists