September 16, 2004 at 4:22 am
I have an NT job scheduled run once in a day. Basically, this NT job executes some SQL stored procedures. I would like to know the status of this job and start another MS SQL Agent Job after the successful completion of this NT job. Please advise.Thanks...
September 16, 2004 at 6:02 am
Why not have the NT batch job start a SQL server JOB that you can interrogate and have that start another job OR
have the NT job kick the sp_start_job that has ALL the steps in it that are required to perform your tasks OR
Just have SQL job scheduled and perform ALL tasks....
Good Hunting!
AJ Ahrens
webmaster@kritter.net
September 16, 2004 at 6:26 am
Here, the problem is, the NT job on another server. we have READ-ONLY access to this. So, somehow we need to findout the status of this NT batch job and start the job on our sever
September 16, 2004 at 4:30 pm
I would research the possibility of having the other SQL server start a job on your SQL server.
The problem as I see it is you don't know WHEN the NT job is going to finish therefore you need to set-up something to check every (n) minutes....
Why not research the possibility of having the NT job drop a file on YOUR server and IF the file exists THEN start??
Good Hunting!
AJ Ahrens
webmaster@kritter.net
September 17, 2004 at 6:44 am
Why not create a JobLog table and have the other job write the status of the job to that table, "Started", "Completed".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply