Metacat

	width: 820px;

	padding-left: 0px;

	width: 200px;

	padding-left: 5px;

	width: 140px;

	width: 140px;

	width: 60px;

	width: 150px;

			<div class="col col4">End Time</div>

			<div class="col col5">Interval</div>

						<xsl:value-of select='./endTime' />		

						<xsl:value-of select='./intervalValue' /><xsl:value-of select='./intervalUnit' /> 		

								<xsl:attribute name="href"><xsl:value-of select='$contextURL' />/metacat?action=unscheduleWorkflow&amp;workflowjobid=<xsl:value-of select='./name' />&amp;qformat=<xsl:value-of select='$qformat' />&amp;forwardto=scheduleWorkflowRun.jsp</xsl:attribute>

								<xsl:attribute name="href"><xsl:value-of select='$contextURL' />/metacat?action=rescheduleWorkflow&amp;workflowjobid=<xsl:value-of select='./name' />&amp;qformat=<xsl:value-of select='$qformat' />&amp;forwardto=scheduleWorkflowRun.jsp</xsl:attribute>

						</a>|						

						<xsl:choose>

						<xsl:when test="./status = 'unscheduled'">

							<a>

								<xsl:attribute name="class">underlined</xsl:attribute>

								<xsl:attribute name="href"><xsl:value-of select='$contextURL' />/metacat?action=deleteScheduledWorkflow&amp;workflowjobid=<xsl:value-of select='./name' />&amp;qformat=<xsl:value-of select='$qformat' />&amp;forwardto=scheduleWorkflowRun.jsp</xsl:attribute>

								Delete	

							</a>

						</xsl:when>

						<xsl:otherwise>

							Delete

						</xsl:otherwise>

						</xsl:choose>		

				} else if (action.equals("deleteScheduledWorkflow")) {

					try {

						WorkflowScheduler.getInstance().deleteJob(request, response, params, 

								userName, groupNames);				

						return;

					} catch (BaseException be) {

						ResponseUtil.sendErrorXML(response, ResponseUtil.DELETE_SCHEDULED_WORKFLOW_ERROR, be);

						return;						

					}

					+ "?workflowid=" + jobParams.get("workflowid") 

					+ "&karid=" + jobParams.get("karid");			

				ScheduledJobParamDAO workflowIdJobParamDAO = jobDAO.getJobParam("workflowid");

				if (workflowIdJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.unScheduleJob - could not find workflow " 

							+ "id when unscheduling job: " + jobName);

				if (karJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.unScheduleJob - could not find kar " 

							+ "id when unscheduling job: " + jobName);

				// we need to include the workflow id in the url

				ScheduledJobParamDAO workflowNameJobParamDAO = jobDAO.getJobParam("workflowname");

				if (workflowNameJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.unScheduleJob - could not find workflow " 

							+ "name when unscheduling job: " + jobName);

				}

					+ "?workflowid=" + workflowIdJobParamDAO.getValue() 

					+ "&karid=" + karJobParamDAO.getValue()

					+ "&workflowname=" + workflowNameJobParamDAO.getValue();

				// we need to include the workflow id in the url

				ScheduledJobParamDAO workflowIdJobParamDAO = jobDAO.getAllJobParams().get("workflowid");

				if (workflowIdJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.reScheduleJob - could not find workflow " 

							+ "id when deleting job: " + jobName);

				// we need to include the workflow id in the url

				if (karJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.reScheduleJob - could not find kar " 

							+ "id when deleting job: " + jobName);

				// we need to include the workflow id in the url

				ScheduledJobParamDAO workflowNameJobParamDAO = jobDAO.getJobParam("workflowname");

				if (workflowNameJobParamDAO == null) {

					throw new MetacatSchedulerException("WorkflowScheduler.reScheduleJob - could not find workflow " 

							+ "name when deleting job: " + jobName);

				}

					+ "?workflowid=" + workflowIdJobParamDAO.getValue()	

					+ "&karid=" + karJobParamDAO.getValue()

					+ "&workflowname=" + workflowNameJobParamDAO.getValue();

				RequestUtil.forwardRequest(request, response, destination);

		 try {

		// workflow job id must exist

		String jobNames[] = params.get("workflowjobid");	

		if (jobNames == null || jobNames.length == 0) {

			throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - workflowjobid field must be populated "

					+ "in scheduler parameters when deleting job.");

		}			

		String jobName = jobNames[0];

		ScheduledJobAccess jobAccess = new ScheduledJobAccess();

		ScheduledJobDAO jobDAO = jobAccess.getJobByName(jobName);

		// delete the job

		SchedulerService schedulerService = SchedulerService.getInstance();

		String result = schedulerService.deleteJob(jobDAO, username, groups);

		// if there is a forwardto param on the request, then send the user to the page

		// referenced in that param, otherwise, just send the xml back.

		String forwardtos[] = params.get("forwardto");

		String forwardto = null;

		if (forwardtos != null && forwardtos.length > 0) {

			forwardto = forwardtos[0];

		}

		if (forwardto != null) {

			String qformats[] = params.get("qformat");

			String qformat = null;

			if (qformats != null && qformats.length > 0) {

				qformat = qformats[0];

			}

			// we need to include the workflow id in the url

			ScheduledJobParamDAO workflowIdJobParamDAO = jobDAO.getAllJobParams().get("workflowid");

			if (workflowIdJobParamDAO == null) {

				throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - could not find workflow " 

						+ "id when deleting job: " + jobName);

			}

			// we need to include the workflow id in the url

			ScheduledJobParamDAO karJobParamDAO = jobDAO.getJobParam("karid");

			if (karJobParamDAO == null) {

				throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - could not find kar " 

						+ "id when deleting job: " + jobName);

			}

			// we need to include the workflow id in the url

			ScheduledJobParamDAO workflowNameJobParamDAO = jobDAO.getJobParam("workflowname");

			if (workflowNameJobParamDAO == null) {

				throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - could not find workflow " 

						+ "name when deleting job: " + jobName);

			}

			String destination = "/style/skins/" + qformat + "/" + forwardto

				+ "?workflowid=" + workflowIdJobParamDAO.getValue()	

				+ "&karid=" + karJobParamDAO.getValue()

				+ "&workflowname=" + workflowNameJobParamDAO.getValue();

			RequestUtil.forwardRequest(request, response, destination);

		} else {

			ResponseUtil.sendSuccessXML(response, result);

		}

		} catch (AccessException ae) {

				throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - DB access issue when deleting job  : ", ae);

		} catch (ServiceException se) {

			throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - Service issue deleting job", se);

		} catch (IOException ioe) {

			throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - I/O issue deleting job: " + ioe.getMessage());

		} catch (ServletException se) {

			throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - Servlet issue deleting job: " + se.getMessage());

		} catch (ErrorSendingErrorException esee) {

			throw new MetacatSchedulerException("WorkflowScheduler.deleteJob - Issue sending erro when deleting job: " + esee.getMessage());			

		}

	public static Long DELETE_SCHEDULED_WORKFLOW_ERROR = new Long(130005);

		errorCodes.put(DELETE_SCHEDULED_WORKFLOW_ERROR, "Delete scheduled workflow error");

			String startTimeStr = DateUtil.getHumanReadable(startCal);

		ScheduledJobDAO jobDAO = null;

			jobDAO = jobAccess.getJobByName(jobName);

							+ "scheduled job : " + jobDAO.getName() + " because of db access issue: ", ae);

	        String startTimeStr = DateUtil.getHumanReadable(startCal);

					+ "job : " + jobDAO.getName() + " because of db access issue: ", ae);

					+ "job : " + jobDAO.getName() + " due to a utility issue: " + ue.getMessage());

	/**

	 * Remove the job from the scheduler and set the job status to deleted in the database

	 * @param jobName

	 *            the string holding the name of the job to delete

	 * @param username

	 *            the user name

	 * @param groups

	 *            the user's group name

	 * @return a message saying that the job was deleted

	 */

	public String deleteJob(String jobName, String username,

			String[] groups) throws ServiceException {

		ScheduledJobDAO jobDAO = null;

		try {	

			ScheduledJobAccess jobAccess = new ScheduledJobAccess();

			jobDAO = jobAccess.getJobByName(jobName);

		} catch (AccessException ae) {

			throw new ServiceException("SchedulerService.deleteJob - Could not delete "

					+ "scheduled job : " + jobDAO.getName() + " because of db access issue: ", ae);

		}

		return deleteJob(jobDAO, username, groups);

	}

	 *            the job data object holding the information about the job to delete

	public String deleteJob(ScheduledJobDAO jobDAO, String username,

			sched.deleteJob(jobDAO.getName(), groupName);

			ScheduledJobAccess jobAccess = new ScheduledJobAccess();

			throw new ServiceException("SchedulerService.deleteJob - Could not delete job: " + jobDAO.getName()

					+ "scheduled job: " + jobDAO.getName() + " because of db access issue: ", ae);

		return "Deleted: " + jobDAO.getName();

					DateUtil.getHumanReadable(scheduledJobDAO.getStartTime());

			jobXML += "<startTime>" + startTimeString + "</startTime>";

			String endTimeString = null;

			try {

				if (scheduledJobDAO.getEndTime() != null) {

					endTimeString = DateUtil.getHumanReadable(scheduledJobDAO.getEndTime());

				}

			} catch (UtilException ue) {

				throw new ServiceException("SchedulerService.jobToXML - error getting human readable date for job: " 

						+ scheduledJobDAO.getId() + " ; " + ue.getMessage());

			}

			jobXML += "<endTime>" + endTimeString + "</endTime>";

			jobXML += "<intervalValue>" + scheduledJobDAO.getIntervalValue() + "</intervalValue>";

			jobXML += "<intervalUnit>" + scheduledJobDAO.getIntervalUnit() + "</intervalUnit>";