Search found 17 matches

by GrandSteph
04 Feb 2014 2:54
Forum: SQL Scripts
Topic: Keep job active after success run
Replies: 8
Views: 16045

That is smart.

Thank you, will try that.
by GrandSteph
29 Jan 2014 3:05
Forum: SQL Scripts
Topic: Keep job active after success run
Replies: 8
Views: 16045

Ok Got that. Thanks. Now, on Monday morning, I'll have all my jobs on hold from Friday night. Chances are, I won't need to rerun any. SO my guess is that when the time for CM refresh comes, I have to execute a script that will remove all scripts on hold from the AJF. Would that work? It's sounds hea...
by GrandSteph
27 Jan 2014 3:50
Forum: SQL Scripts
Topic: Keep job active after success run
Replies: 8
Views: 16045

Thanks Guys. Unfortunatly none of the answer are satisfying to me. We are really looking for a way to do this without manual intervention. Meaning, we want to eventually rerun a job on monday that was posted on Friday (it happens only a very limited number of time). Only whenever an issue occured an...
by GrandSteph
23 Jan 2014 6:13
Forum: SQL Scripts
Topic: Keep job active after success run
Replies: 8
Views: 16045

Keep job active after success run

Hi all, Is it possible to keep a job active after a succesfull run for several days? Basically today, we can't rerun a job on Monday morning that was executed on friday evening because all succesfull jobs are removed from the active queue when we do a refresh every day. After the refresh only pendin...
by GrandSteph
09 Feb 2012 10:26
Forum: Exploitation / Operation
Topic: Finished job doesn't turn green
Replies: 14
Views: 12379

Actually, just modified the batch file to just do one thing:

exit 0

And the job stays yelloy whereas log shows that it went thru exit 0...
by GrandSteph
09 Feb 2012 9:34
Forum: Exploitation / Operation
Topic: Finished job doesn't turn green
Replies: 14
Views: 12379

Will try that.
by GrandSteph
09 Feb 2012 8:38
Forum: Exploitation / Operation
Topic: Finished job doesn't turn green
Replies: 14
Views: 12379

The job starts a server

start /B "" "C:\Program Files\xxxx\Server.exe"
by GrandSteph
09 Feb 2012 6:11
Forum: Exploitation / Operation
Topic: Finished job doesn't turn green
Replies: 14
Views: 12379

Finished job doesn't turn green

We have a job that is just starting a server. When ran from an ms-dos batch file, the msdos window will close just fine while the server is up and running. When triggering thru Control-M, the sysous produces a weird number at the last line (here is the actual sysout output) echo Success Success exit...
by GrandSteph
09 Feb 2012 6:07
Forum: Job Definition
Topic: Monday morning jobs
Replies: 6
Views: 5685

That wouldn't work because then I need to create a job on monday. That is what I'm trying to avoid. How about passing the next business date to the job and have the job wait for thenext business date. That would translate into, the job triggers on Friday night but knows that the next business date i...
by GrandSteph
19 Jan 2012 5:43
Forum: Job Definition
Topic: Monday morning jobs
Replies: 6
Views: 5685

I'm not sure it addresses my need. Maybe I don't understand your answer.
I want to order the job on Friday, but I want it to run on Monday morning as part of Friday night's batch.
by GrandSteph
18 Jan 2012 10:15
Forum: Job Definition
Topic: Monday morning jobs
Replies: 6
Views: 5685

Monday morning jobs

Hi all, I'm having a bit of an issue here. As many businesses we run our batch daily monday night thru friday night. How would you schedule a job that has to run on monday morning, but really is connected to friday night's batch? (specifically, jobs running Monday morning are dependant on job runnin...
by GrandSteph
11 Jan 2012 8:41
Forum: Job Definition
Topic: Conditional in-condition
Replies: 3
Views: 7617

Thanks fafa and chris,
both proposal look promising, I'll try them.
Chris' looks too good to be true ;)
by GrandSteph
09 Jan 2012 11:00
Forum: Job Definition
Topic: Conditional in-condition
Replies: 3
Views: 7617

Conditional in-condition

Can I define a job that will trigger if:
1 - In condition is met
or
2 - In condition does not exist ?

Basically trying to get a JOB A dependant on JOB B and JOB C only if JOB B exists, if JOB B doesn't exist then just have JOB A dependant on JOB C.

Thanks.
by GrandSteph
14 Dec 2011 7:33
Forum: Job Definition
Topic: Calendar update
Replies: 2
Views: 2653

Thank you. Will try that.
by GrandSteph
12 Dec 2011 4:24
Forum: Job Definition
Topic: Calendar update
Replies: 2
Views: 2653

Calendar update

Hi all,
Is is possible to update the name of a calendar and auto-update all jobs using this calendar?

Basically, we have a Calendar that is badly named :? but used by many jobs and we need to rename it.

Thank for any help!