It is OK when I run the command, exec sys.DBMS_SCHEDULER.run_JOB('SYS.My_Job'); on sql *Plus.
An error, "PLS-00103: Encountered the symbol \"SYS\" when expecting one of the following:\n\n,,." was received when I tried to call DBMS_SCHEDULER jobs using DBMS_SCHEDULER.run_job from CommandText in C# as the following.
Oracle.DataAccess.Client.OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "exec sys.DBMS_SCHEDULER.run_job('SYS','My_Job');";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = conn;
I would appreciate if you can help me. Thanks.
cyh