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]

connect with HI Team, they will access your instance and inspect the issue. 

[Harsh Vardhan]

can you confirm one thing, in run as field did you mention your user id?

[rpatnaik]

No i kept it as 'System Administrator'

[Harsh Vardhan]

set your user id and test 

[rpatnaik]

Tried that as well Harsh...But no luck