batch job are automaticly deleted

[Former Member]

Hi,

from two weeks I've been struggling with deleted batch jobs. One day I noticed my batch job are deleted automaticly, but not every

batch job and not every day.

It seems the batch jobs are choosen by random.

One day I schedule missing job and I see it in TaskScheduler (mu user), and after one day or more I see that this job is deleted by system

user: NT AUTHORITY\System.

And up to that time everything works correctly from 2 years.

What is could be important about that day we copied this prod repository database to our test server but I created new job server etc.

My DS version: 4.0 SP3

SQL Server 2008

Windows Server 2008 R2 Enterprise

Where could be the problem in WindowsServer or rather in repository?

Regards

[Former Member]

Hi,

I run sp_depends AL_Sched_Info and I got below message:

Object does not reference any object, and no objects reference it.

Is it possible that something from copied database delete this batch jobs?

Regards

[mageshwaran_subramanian]

Can you check the task setting, see if it is enabled?

[Former Member]

Hi,

It's strange - I know

I think some script could do it but what is strange - not every batch jobs are deleted, and even for example: job X wasn't deleted one day in two days it could be deleted. It happens randomly.

But when I can find if any script is run?

In task scheduler I see batch jobs but - as I wrote in first post - when something delete my batch job I lost this in task scheduler and when I create batch job one more time I can find in hostory that it was deleted by NT AUTHORITY\System and it happens at diffrent time.

Even batch job is deleteed in repository table AL_Sched_Info still this deleted job is active.

Regards

[former_member198401]

Rad,

Probably you should catch hold of Sys Admin to dig in to the issue. BODS has no automated script which deletes the scheduled jobs or objects

Regards

Arun Sasi

[mageshwaran_subramanian]

Since you use SQL server , can you try this query in repo DB

sp_depends AL_Sched_Info

This is to find out if there's any other object such as a DB trigger that may delete the table entry.

[mageshwaran_subramanian]

Are the jobs just missing or they have been deleted?

Do you see entries in repository metadata tables for those deleted(?) jobs?

[former_member198401]

Thats strange

Can you check if there is any scheduled batch script(.bat) running in the system. It might be possible that the script is deleting all the scheduled tasks from the Task scheduler. DS jobs schedules are created as Tasks in task Scheduler

Regards

Arun Sasi