Scheduled Scripts (Cron)#

{
  type: "cron",
  cronExpression: "0 9 * * *",  // The cron expression
  scheduledTime: "2024-01-15T09:00:00.000Z"  // When this execution was scheduled
}

console.log("Generating daily report at:", event.scheduledTime);

// Find all work items created yesterday
const yesterday = new Date();
yesterday.setDate(yesterday.getDate() - 1);
const dateStr = yesterday.toISOString().split('T')[0];

const jql = `created >= "${dateStr}" AND created < "${dateStr}" + 1d`;
const response = await requestJira(
  route`/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=0`
);
const result = await response.json();

console.log(`Work items created yesterday: ${result.total}`);

// You could store this in a custom field, create a confluence page,
// or send to an external reporting system

console.log("Checking for stale work items...");

// Find work items not updated in 14+ days
const jql = `status != Done AND updated <= -14d ORDER BY updated ASC`;
const response = await requestJira(
  route`/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=50`
);
const result = await response.json();

console.log(`Found ${result.total} stale work items`);

// Add a comment to each stale work item
for (const issue of result.issues) {
  await requestJira(
    route`/rest/api/3/issue/${issue.key}/comment`,
    {
      method: "POST",
      headers: { "Content-Type": "application/json" },
      body: JSON.stringify({
        body: {
          type: "doc",
          version: 1,
          content: [{
            type: "paragraph",
            content: [{
              type: "text",
              text: "This work item has not been updated in over 14 days. Please review and update status."
            }]
          }]
        }
      })
    }
  );
  console.log(`Reminded on: ${issue.key}`);
}

console.log("Running monthly sprint cleanup...");

// Find completed work items without resolution
const jql = `status = Done AND resolution = EMPTY`;
const response = await requestJira(
  route`/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=100`
);
const result = await response.json();

console.log(`Found ${result.total} work items needing resolution`);

// Set resolution to "Done" for each
for (const issue of result.issues) {
  await requestJira(
    route`/rest/api/3/issue/${issue.key}`,
    {
      method: "PUT",
      headers: { "Content-Type": "application/json" },
      body: JSON.stringify({
        fields: {
          resolution: { name: "Done" }
        }
      })
    }
  );
  console.log(`Set resolution on: ${issue.key}`);
}

console.log("Checking SLA compliance...");

// Find high priority work items older than 4 hours without assignee
const jql = `priority = Highest AND assignee = EMPTY AND created <= -4h AND status != Done`;
const response = await requestJira(
  route`/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=50`
);
const result = await response.json();

if (result.total > 0) {
  console.log(`WARNING: ${result.total} high priority work items unassigned for 4+ hours`);

  // Assign to default responder
  const defaultAssignee = process.env.DEFAULT_RESPONDER_ID;

  for (const issue of result.issues) {
    await requestJira(
      route`/rest/api/3/issue/${issue.key}`,
      {
        method: "PUT",
        headers: { "Content-Type": "application/json" },
        body: JSON.stringify({
          fields: {
            assignee: { accountId: defaultAssignee }
          }
        })
      }
    );
    console.log(`Auto-assigned: ${issue.key}`);
  }
} else {
  console.log("All high priority work items are assigned");
}

console.log("Generating end-of-day summary...");

const today = new Date().toISOString().split('T')[0];

// Count work items by status changed today
const statusStats = {};
const jql = `statusCategory changed DURING ("${today}", "${today}")`;

const response = await requestJira(
  route`/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=200`
);
const result = await response.json();

for (const issue of result.issues) {
  const status = issue.fields.status.name;
  statusStats[status] = (statusStats[status] || 0) + 1;
}

console.log("Work items by current status:");
for (const [status, count] of Object.entries(statusStats)) {
  console.log(`  ${status}: ${count}`);
}

console.log(`Total work items with status changes: ${result.total}`);