WORKLOADAUTOMATION.ORG | The Global Community: SQL Server jobs with 4.5 - WORKLOADAUTOMATION.ORG | The Global Community

Jump to content

Welcome

This is the workload automation community forum.

Join us now and share your experiences, knowledge and request assistance. Once registered and logged in, you will be able to create topics, post replies, share code, and speak privately with members with your own private messenger.


Come and join in...

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

SQL Server jobs with 4.5

#1 User is offline   Arun Prasad Icon

  • Members

Post icon  Posted 06 October 2008 - 07:35 PM

Hi All,

I had a quick question regarding scheduling SQL Server jobs in 4.5. Since most of it is done from the Enterprise Manager GUI, I was wondering if there was a way to schedule them via command line. This way it can be wrapped in a simple batch script.

Can something like that be done? Am I just missing something really simple here? :unsure: Does anyone have any suggestions on this?

Any and all comments/suggestions welcome.

Thanks,
Arun
0

#2 Guest_Timmy_*

  • Guests

Posted 06 October 2008 - 07:45 PM

Hi Arun,

What in particular do you wish to execute, Stored Procedures or DTS Packages?

DTS Packages can be executed using DTSRun or DTExec

Timmy
0

#3 User is offline   Arun Prasad Icon

  • Members

Posted 06 October 2008 - 08:00 PM

Thanks Timmy.

Out of curiosity, if I wanted to run stored procs, what would be the way to handle those?
0

#4 Guest_Timmy_*

  • Guests

Posted 06 October 2008 - 08:17 PM

QUOTE (Arun Prasad @ Oct 6 2008, 09:00 PM) <{POST_SNAPBACK}>
Thanks Timmy.

Out of curiosity, if I wanted to run stored procs, what would be the way to handle those?

Thats tends to be a little trickier.

Either you would need to get some form of wrapper developed or you could use osql however from my experience osql error trapping is limited.

Timmy
0

#5 Guest_Eric_*

  • Guests

Post icon  Posted 06 October 2008 - 10:38 PM

AutoSys has to come a very long way to match the MS SQL Server integration of Tidal's Enterprise Scheduler... although no doubt it'll get there in the end.
0

#6 User is offline   Ant Icon

  • Members

Posted 07 October 2008 - 07:46 AM

We await AutoSys r11.3 plus all the fancy new (cybermation) agents, with baited breath.

In the meantime...

:tumbleweed:
0

#7 User is offline   dr_jay Icon

  • Members

Posted 27 July 2009 - 01:33 PM

Can any one please provide me with this help. I am new to SSIS. I have a SSIS package that has to be executed through Tidal scheduler. need to know the way by which it can be done. I need to catch the status of teh packageexecution (success of failure along with reason) and send in mail when the execution completes.
Please help. I need to have the code and configuration changes .
0
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic


IPB skins by Skinbox
Quality IPB skins, premium vBulletin styles, cheap Web templates and more!