msdbjobtestcase.java

MM7彩信对接网关示例

/*
 * Created on 2005-8-5
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.rainbow.msdbjob;

import junit.framework.TestCase;

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class MsDbJobTestCase extends TestCase {

	public static void main(String[] args) {
		MsDbJob job = new MsDbJob("16", "hi", "sa", 1);
		
		MsDbJobSchedule s = new MsDbJobSchedule("step1");
		s.setEnabled(1);
		System.out.println(job.addJobSchedule(s));
		
		MsDbJobStep ss = new MsDbJobStep("step11");
		ss.setDbName("MMSDB");
		ss.setCommand("select getdate()");
		ss.setStepID(1);
		ss.setUserName("sa");
		System.out.println(job.addJobStep(ss));
		
		MsDbJobStep ss2 = new MsDbJobStep();
		ss2.setCommand(ss.getCommand());
		ss2.setDbName(ss.getDbName());
		ss2.setServer(ss.getServer());
		ss2.setStepID(ss.getStepID());
		ss2.setStepName("step22");
		ss2.setUserName(ss.getUserName());
		System.out.println(job.addJobStep(ss2));
		
		MsDbJobSchedule s1 = new MsDbJobSchedule();
		s1.setScheduleName("step2");
		s1.setEnabled(1);
		System.out.println(job.addJobSchedule(s1));
		
		//System.out.println(MsDbJob.deleteJob(job));
		MsDbJob job2 = new MsDbJob("16");
		System.out.println(job2.getJobSteps());
		System.out.println(job2.getJobSchedules());
		
		//MsDbJob job2 = new MsDbJob("16", "hi", "sa", 1);
		//System.out.println(MsDbJob.deleteJob(job2.getJobID()));
	}

}