CA Autosys & SQL Server Agent

[Apollo21]

We would like to have the SQL Server Agent send notification to Computer Associates Autosys product.
Has anyone had any experience along these lines, and if so what did you do to make them talk to each other.

(This is for the purpose of indicating to our operators the state of the backup that SQL Server is running through a maintenance plan)

 

[mrdenny]

Why not have autosys run the code for the maintaince plan?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Apollo21]

OK - but how is that accomplished? I am new to this game. I understand that autosys can run scripts, but how do I get the script out of the maintenance plan?

Thank you.

 

[mrdenny]

Get the command from the job in the SQL Agent, then have autosys run that command. You may need to have it run via osql and put it within an xp_cmdshell.

Be sure that any time you update the maintaince plan you put the new command in autosys.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)