[Technical] Schedule an export from cases?

[Clark, Ian C]

> -----Original Message-----
> From: tech-bounces at edulists.com.au 
> [mailto:tech-bounces at edulists.com.au] On Behalf Of Chris Hopkinson
> Sent: Thursday, 2 March 2006 2:02 PM
> To: 'Technical Discussion in Schools Mailing List'
> Subject: [Technical] Schedule an export from cases?
> 
> I have a another question on Cases 21 that I would like to 
> solve. At Bairnsdale SC we have setup a couple of export 
> queries that sends Cases 21 data to text files. The text 
> files are then used by various other programs (such as 
> timetabling and attendance systems).
> 
> I am looking for a way to automate the export from cases21. 
> Is there any way that we can schedule this to happen once a day?

There are a number of triggers that do this sort of stuff already on the
server, Chris ... some of these jobs run nightly ... you can bring in a
SQL Server expert to write some for you or to do a Data Transformation
Services job (can export to other servers, for instance).

Be aware that any updates by the Department's TSU (Technical Services
Unit) might also wipe out your customizations, so you'd better consult
with them. 

For instance, these updates can wipe out any customizing you did to the
daily tape backup routine (schools have been known to add curriculum
shares to the backup job!).

Cheers,
Clarky 


Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.