Errors When Editing A Saved Scheduled Job

[Purple Edge]

If I choose the “SQL Scheduler and Reporting Tool” and choose the deault saved job that I have created I get an error – see attached.

It is possibly because the default job shown was not created with this menu option but another of the “wizards”?

See attached.

[peterlaursen]

I do not understand the question “It is possibly because the default job shown was not created with this menu option but another of the “wizards”?”

If you for instance save a jobfile for a Scheduled Backup job and open that file in the Data Sync wizard I am not sure what will happen. It was never intended to work! But if we don't already we should prompt an error!

[Purple Edge]

Hi, thanks, that is what happens – the default job that appears in the entry field is the name of the last job created. In my case it was a backup job, or synchronizer job, not a job created with “SQL Scheduler and Reporting Tool”. Perhaps the simplest solution is to leave that field blank and force us to select a saved job created with the SSRT?

A better solution would be to create an extension specific for each job type – so jobs created with SSRT would have an .SSRT extension instead of using .XML for everything? That would make it easier for us to know what type of job we are working with too?

[peterlaursen]

You can use what file extension you want. It does not need to be .XML.

We have also documented this (in anotehr context): http://www.webyog.com/faq/content/27/74/en/how-do-i-execute-a-job-with-sja-with-a-single-mouse_click.html:

“SJA does not need the file extension to be .xml. It can be anything. So you can create a new jobfile (or rename an existing one) to use the suffix .sjajob ….”

[Author]

Posts